sp_link_publication (T-SQL)

Sets the configuration and security information used by synchronization triggers of immediate updating Subscribers when connecting to the Publisher.

Syntax

sp_link_publication [@publisher =] 'publisher',
    [@publisher_db =] 'publisher_db', [@publication =] 'publication',
    [@security_mode =] security_mode [,[@login =] 'login']
    [,[@password =] 'password']

Arguments

[@publisher =] 'publisher'

Is the name of the Publisher to link to. publisher is sysname, with no default.

[@publisher_db =] 'publisher_db'

Is the name of the Publisher database to link to. publisher_db is sysname, with no default.

[@publication =] 'publication'

Is the name of the publication to link to. publication is sysname, with no default.

[@security_mode =] security_mode

Is the security mode used when linking to the Publisher. security_mode is int, with no default. If 0, the synchronization triggers use a dynamic RPC connection to the Publisher. If 2, the synchronization triggers use a static sysservers entry to do RPC, and publisher must be defined in the sysservers table as a remote server or linked server.

[@login =] 'login'

Is the login. login is sysname, with a default of NULL.

[@password =] 'password'

Is the password. password is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_link_publication is used by immediate updating Subscribers in snapshot and transactional replication.

sp_link_publication can be used for both push and pull subscriptions. It can be called before or after the subscription is created. An entry is inserted or updated in the MSsubscription_properties system table. Use sp_helpsubscription_properties to view the values (publisher_security_mode, publisher_login, publisher_password) being set.

For push subscriptions, the entry can be cleaned up by sp_subscription_cleanup. For pull subscriptions, the entry can be cleaned up by sp_droppullsubscription or sp_subscription_cleanup. You can also call sp_link_publisher with a NULL password to clear the entry in the MSsubscription_properties system table for security concerns.

Permissions

Only members of the sysadmin fixed server role can execute sp_link_publication.

See Also