sp_addsubscription (version 6.5)

Adds a subscription to an article and sets the subscriber's status. sp_addsubscription prevents DSN subscribers to publications that:

• Were created with the native @sync_method in the call to the sp_addpublication stored procedure.

Or

• Contain articles that were added to the publication with an sp_addarticle stored procedure that had a pre_creation_cmd parameter of 3 (truncate).

For additional syntax information for sp_addsubscription, see the Microsoft SQL Server Transact-SQL Reference.