Generates a script that contains the sp_addsynctrigger calls to be applied at Subscribers for immediate-updating subscriptions. There is one sp_addsynctrigger call for each article in the publication.
sp_script_synctran_commands [@publication =] 'publication'
[,[@article =] 'article']
0 (success) or 1 (failure)
sp_script_synctran_commands returns a result set that consists of a single nvarchar(4000) column. The result set forms the complete script necessary to create the sp_addsynctrigger calls to be applied at Subscribers.
sp_script_synctran_commands is used in snapshot and transactional replication.
Execute permissions default to the public role.
sp_addsynctriggers | System Stored Procedures |