Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rio.rohit22
Starting Member
11 Posts |
 Posted - 2010-02-12 : 14:33:20
|
| Hey friends,I have a default instance running on SQL Server 2005, i had done replication for a database from a production server to backup server but somehow something went wrong, now i need to delete this replication. I have deleted Subscriber successfully. The problem is that i cannot delete Publisher and Distributor from my production server. Whenever i try to delete publisher SQL Server hangs up and users cannot access it, also it never gives any warning massage or any error, I have to do end task to sqlserver.exe.Please help meThanks in advance |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-02-12 : 15:25:03
|
| Try the sp_removedbreplication proc to clean up replication objects.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rio.rohit22
Starting Member
11 Posts |
Posted - 2010-02-15 : 07:26:27
|
| thnanks dinakar...problem solved.... cheers |
|
|
|
|
|
|
Unable to delete publisher and distributor