sys.sp_refreshsubscriptions
general #stored-procedure
Description
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. Specifies the publication for which to refresh subscriptions. Identified for informational purposes only. Not supported.
Syntax
sp_refreshsubscriptions
[ @publication = ]
N
'publication'
[ , [ @publisher = ]
N
'publisher'
]
[ ; ]
Permissions
is used in snapshot, transactional, and merge replication. is called by for an immediate-updating publication. Only members of the fixed server role or the fixed database role can execute. sp_addarticle (Transact-SQL) System stored procedures (Transact-SQL)