Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000, or do you have to use Enterprise Manager or SQL-DMO as mentioned in SQL Server Books Online?
-
Just to clarify - do you mean replication or log shipping?– Brent OzarMay 18, 2009 at 13:24
-
replication. Does replication use log shipping or is it completely unrelated?– Alan HechtMay 18, 2009 at 13:48
-
They're totally unrelated, so that's why I wanted to clarify it. Thanks for answering so quickly!– Brent OzarMay 18, 2009 at 13:53
Add a comment
|
1 Answer
There is this system stored procedure sp_reinitsubscription, which marks the subscription for reinitialization. Here is the Transact-SQL Reference for SQL Server 2000.
Syntax:
sp_reinitsubscription [ [ @publication = ] 'publication' ]
[ , [ @article = ] 'article' ]
, [ @subscriber = ] 'subscriber'
[ , [ @destination_db = ] 'destination_db']
[ , [ @for_schema_change = ] 'for_schema_change']
Only members of the sysadmin fixed server role, members of the db_owner fixed database role, or the creator of the subscription can execute it.
answered May 18, 2009 at 13:51
