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

Question

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?

Answer 1

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.