Tuesday, December 17, 2013

How to drop distribution database

I just tested Transactional Replication Today on  test server as we( our client)  are going to have replication on our two big Databases

 so ...


After setting up Replication and  wanted to remove  all replication jobs, databases.. Distribution Database wont get dropped . so us below script to drop the distribution database


use master
go
alter database distribution1 set offline;
drop database distribution1;

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...