SQL Server Performance Forum – Threads Archive

Disabling repl error

one week ago, for testing purpose, I set up trans repl, trans repl with updateable, snapshot repl using the same instance. configuration is like this, publisher and distributor are on the same server, 2 remote subscribers, one is 2000, the other is 2005. It works OK, today I am trying to disable the replicaiton, clean up the machine. keep getting the errors: an exception occurred while executing a T-SQL statement or batch only replicaiton jobs,or job schedules can be added, modified,dropped or viewed through replicaiton SPs could not update the distribution database subscription table, the subscription status could not be changed. changed database context to ‘master’,(MSSQL SERVER error 2253<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Please help —————— Bug explorer/finder/seeker/locator ——————

publisher: 2005 Standard SP2 CTP ——————
Bug explorer/finder/seeker/locator
——————

Why you want to still keep CTP? MohammedU.
Moderator
SQL-Server-Performance.com

Test server, testing for SP2 enhancement
——————
Bug explorer/finder/seeker/locator
——————

Got it… Sorry! I misread… it is SP2 CTP not SQL 2005 CTP<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> MohammedU. Moderator SQL-Server-Performance.com

You got it? MohammedU, then what do you think……….. I am guessing it is because of the linked server settings. Searched a lot of places, could not find something valuable. one things may give you guys clues, for the Trans Repl with updateable subscribers, I could not be able to update the subscribers because of the linked server setting, I just guess see this link, may related..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=274139&SiteID=1 ——————
Bug explorer/finder/seeker/locator
——————

May be your right… relate to Linked server …
Did you try running linked server query between the publisher and subscriber?
Try removing replication manually using procedures…
MohammedU.
Moderator
SQL-Server-Performance.com

Do you get the same on a SQL 2005 SP1 setup? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

To Satya, sorry, I only did this on SP2 CTP, don’t know will this happen to SP1. To Mohammed, I tested all the linked servers, it seems work. will try using sps. ——————
Bug explorer/finder/seeker/locator
——————

Similar problem, I guess it is realted with the communication between publisher and distributor http://www-new.experts-exchange.com…ver/Q_21962875.html?qid=21962875&qid=21962875 ——————
Bug explorer/finder/seeker/locator
——————

]]>