Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_addqueued_artinfo (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_addqueued_artinfo (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Important note Important

The sp_script_synctran_commands procedure should be used instead of sp_addqueued_artinfo. sp_script_synctran_commands generates a script that contains the sp_addqueued_artinfo and sp_addsynctrigger calls.

Creates the MSsubscription_articles table at the Subscriber that is used to track article subscription information (Queued Updating and Immediate Updating with Queued Updating as Failover). This stored procedure is executed at the Subscriber on the subscription database.

Topic link icon Transact-SQL Syntax Conventions

sp_addqueued_artinfo [ @artid= ] 'artid' 
        , [ @article= ] 'article' 
        , [ @publisher = ] 'publisher' 
        , [ @publisher_db = ] 'publisher_db' 
        , [ @publication = ] 'publication' 
        , [ @dest_table= ] 'dest_table' 
        , [ @owner = ] 'owner' 
        , [ @cft_table= ] 'cft_table'

[ @artid= ] 'artid'

Is the name of the article ID. artid is int, with no default

[ @article=] 'article'

Is the name of the article to be scripted. article is sysname, with no default

[ @publisher=] 'publisher'

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

[ @publisher_db=] 'publisher_db'

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

[ @publication=] 'publication'

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

[ @dest_table= ] 'dest_table'

Is the name of the destination table. dest_table is sysname, with no default.

[@owner = ] 'owner'

Is the owner of the subscription. owner is sysname, with no default.

[ @cft_table= ] 'cft_table'

Name of the queued updating conflict table for this article. cft_tableis sysname, with no default.

0 (success) or 1 (failure)

sp_addqueued_artinfo is used by the Distribution Agent as part of subscription initialization. This stored procedure is not commonly run by users, but may be useful if the user needs to manually set up a subscription.

sp_script_synctran_commands instead of sp_addqueued_artinfo.

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

Community Additions

© 2015 Microsoft