Collapse the table of content
Expand the table of content


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.


sp_createmergepalrole [ @publication = ] 'publication'


[@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)


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.


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

See Also



System Stored Procedures

© 2016 Microsoft