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?
Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000
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
There is this system stored procedure
sp_reinitsubscription, which marks the subscription for reinitialization. Here is the Transact-SQL Reference for SQL Server 2000.
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.