sp_refreshsubscriptions (Transact-SQL)
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 = ] 'publication'
Arguments
[ @publication = ] 'publication'
Is the publication for which to refresh subscriptions. publication is sysname, with no default.
Return Code Values
0 (success) or 1 (failure)
Result Sets
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.
See Also
sp_addarticle (Transact-SQL)
System Stored Procedures (Transact-SQL)
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