Home / server / Questions / 9411
Accepted
Alan Hecht
Asked: 2009-05-19 05:19:02 +0800 CST

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000

  • 772

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?

sql-server replication

1 Answers

  1. Best 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.

    • 4