sp_script_synctran_commands (Transact-SQL)
Applies to: SQL Server
Generates a script that contains the sp_addsynctrigger
calls to be applied at Subscribers for updatable subscriptions. There's one sp_addsynctrigger
call for each article in the publication. The generated script also contains the sp_addqueued_artinfo
calls that create the MSsubsciption_articles
table that is needed to process queued publications. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL syntax conventions
Syntax
sp_script_synctran_commands
[ @publication = ] N'publication'
[ , [ @article = ] N'article' ]
[ , [ @trig_only = ] trig_only ]
[ , [ @usesqlclr = ] usesqlclr ]
[ ; ]
Arguments
[ @publication = ] N'publication'
The name of the publication to be scripted. @publication is sysname, with no default.
[ @article = ] N'article'
The name of the article to be scripted. @article is sysname, with a default of all
, which specifies all articles are scripted.
[ @trig_only = ] trig_only
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[ @usesqlclr = ] usesqlclr
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Return code values
0
(success) or 1
(failure).
Result sets
sp_script_synctran_commands
returns a result set that consists of a single nvarchar(4000) column. The result set forms the complete scripts necessary to create both the sp_addsynctrigger
and sp_addqueued_artinfo
calls to be applied at Subscribers.
Remarks
sp_script_synctran_commands
is used in snapshot and transactional replication.
sp_addqueued_artinfo
is used for queued updatable subscriptions.
Permissions
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_script_synctran_commands
.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru