![]() ![]() ![]() If the Publisher uses a remote Distributor, execute sp_dropdistributor.Īt the Distributor, execute sp_dropdistpublisher. This stored procedure will not remove replication jobs at the Distributor.Īt the Publisher on the publication database, execute sp_removedbreplication to remove replication objects from the database. "Agent Security Under SQL Server Agent" section of Replication Agent Security Model.Īt each Subscriber on the subscription database, execute sp_removedbreplication to remove replication objects from the database. When prompted for a schedule for the snapshot agent, choose any time that is not right now. From your comment, you apparently had success re-enabling replication, and then removing it properly using the information contained in the post entitled Disable Publishing and Distribution.Ĭreate a new publication with only one article (which we are about to delete anyway). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |