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.