-- Drop Subscriber -- connect Subscriber Server and drop pull subscription :connect MYSERVER103\Subscriber use [ReplPlaygroundSub] exec sp_droppullsubscription @publisher = N'MYSERVER101\Publisher', @publisher_db = N'ReplPlayground', @publication = N'TestPublication' go -- Connect Publisher Server :connect MYSERVER101\Publisher -- Drop Subscription use [ReplPlayground] exec sp_dropsubscription @publication = N'TestPublication', @subscriber = N'MYSERVER103\Subscriber', @destination_db = N'ReplPlaygroundSub', @article = N'all' go -- Drop publication use [ReplPlayground] exec sp_droppublication @publication = N'TestPublication' -- Drop use [ReplPlayground] exec sp_replicationdboption @dbname = N'ReplPlayground', @optname = N'publish', @value = N'false'