Information about fields in replicate articles includes:
Database server name and database name of the replicate database
Subscription name
Owner of the replicate object
Name of the replicate object
Replicate stored procedure group number (stored procedures only)
Type of the replicate object (table or stored procedure)
Replicate field identifier (ordinal position)
Replicate field name (column name or parameter name)
Datatype of the field
Precision of the datatype (precision of numeric datatypes, or length of string or binary datatypes)
Scale of the datatype (numeric datatypes only)
Publication name
Owner of the primary article
Name of the primary article
Primary stored procedure group number (stored procedures only)
Primary field identifier (ordinal position)
Primary field name (column name or parameter name)
You must qualify a replicate article by subscription or by replicate database when you request field information.
To get information about fields in a specific
replicate article in a specific subscription
Use sp_helpreplicateart with the fields keyword, and specify a replicate article name and a subscription:
sp_helpreplicateart fields, rep_art, sub=sub_name
where rep_art is the name of the replicate article, and sub_name is the name of a subscription.
To get information about fields in a specific
replicate article in a specific replicate database
Use sp_helpreplicateart with the fields keyword, and specify a replicate article name and a replicate database connection:
sp_helpreplicateart fields, rep_art, conn="conn_name"
where rep_art is the name of the replicate article, and conn_name is the name of a replicate database connection.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
