Edit

Share via

sp_refreshsubscriptions (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Add subscriptions to new articles for all the existing Subscribers to an immediate-updating publication. This stored procedure is executed at the Publisher on the publication database.

Transact-SQL syntax conventions

Syntax

syntaxsql 
sp_refreshsubscriptions
    [ @publication = ] N'publication'
    [ , [ @publisher = ] N'publisher' ]
[ ; ]

Arguments

[ @publication = ] N'publication'

Specifies the publication for which to refresh subscriptions. @publication is sysname, with no default.

[ @publisher = ] N'publisher'

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

sp_refreshsubscriptions is used in snapshot, transactional, and merge replication.

sp_refreshsubscriptions is called by sp_addarticle for an immediate-updating publication.

Permissions

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

Related content