Export (0) Print
Expand All
Expand Minimize

sp_showrowreplicainfo

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Displays information about a row in a table that is being used as an article in merge replication. This stored procedure is executed at the computer and in the database where the table is stored.

Syntax

sp_showrowreplicainfo [ [ @ownername = ] 'ownername' ]
    [, [ @tablename =] 'tablename']
    , [ @rowguid =] rowguid
    [ , [ @show = ] 'show' ]

Arguments

[@ownername = ] 'ownername'

Is the name of the table owner. ownername is sysname, with a default of NULL.  This parameter is useful to differentiate tables if a database contains multiple tables with the same name, but each table has a different owner.

[@tablename =] 'tablename'

Is the name of the table that contains the row for which to information is returned. tablename is sysname, with no default.

[@rowguid =] rowguid

Is the unique identifier of the row. rowguid is uniqueidentifier, with no default.

[@show = ] 'show'

Determines the amount of information to return in the result set. show is nvarchar(20) with a default of BOTH. If row, only row version information will be returned. If columns, only column version information will be returned. If both, both row and column information will be returned.

Result Sets for Row Information
Column name Data type Description
server_name   Name of the server hosting the database that made the row version entry.
db_name   Name of the database that made this entry.
db_nickname   Nickname of the database that made this entry.
version   Version of the entry.
rowversion_table   Indicates whether the row versions are stored in the MSmerge_contents table or the MSmerge_tombstone table.
comment   Additional information about this row version entry. Usually, this field is empty.

Result Sets for Column Information
Column name Data type Description
server_name   Name of the server hosting the database that made the column version entry.
db_name   Name of the database that made this entry.
db_nickname   Nickname of the database that made this entry.
version   Version of the entry.
colname   Name of the article column that the column version entry represents.
comment   Additional information about this column version entry. Usually, this field is empty.

Result Set for both

If the value both is chosen for @show, then both the row and column result sets will be returned.

Remarks

sp_showrowreplicainfo is used in merge replication.

Permissions

Only members of the db_owner fixed database role or the publication access list for the current publication can execute sp_showrowreplicainfo.

See Also

Publication Access Lists

Merge Replication Conflict Detection and Resolution

System Stored Procedures

Show:
© 2014 Microsoft