Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Just to clarify - do you mean replication or log shipping? – Brent Ozar May 18 '09 at 13:24
replication. Does replication use log shipping or is it completely unrelated? – Alan Hecht May 18 '09 at 13:48
They're totally unrelated, so that's why I wanted to clarify it. Thanks for answering so quickly! – Brent Ozar May 18 '09 at 13:53
up vote 4 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.