Export (0) Print
Expand All
Expand Minimize

sp_createmergepalrole

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Creates a new SQL Server role used in merge replication. Although this new role should be automatically created when SQL Server 2000 Service Pack 3 is applied, you can execute sp_createmergepalrole to recreate the role if you ever lose it. This stored procedure is executed at the Publisher on the publication database to recreate the role.

Syntax

sp_createmergepalrole [ @publication = ] 'publication'

Arguments

[@publication = ] 'publication'

Is the publication name. publication is sysname, with no default. This parameter is used to select the publication to use when recreating a role used by merge replication.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_createmergepalrole is used in merge replication.

Executing sp_createmergepalrole adds a new rowto the sysusers table for the new role. The name of this new role is based on the value of the pubid column in the sysmergepublications table for the given publication. The prefix of the role name is 'MSMerge_' and the pubid value is appended (without the hyphens) to the role name.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_createmergepalrole.

See Also

sysmergepublications

sysusers

System Stored Procedures

Show:
© 2014 Microsoft