Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
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.