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 |
|
xiebo2010cx
Starting Member
4 Posts |
 Posted - 2007-02-02 : 10:27:54
|
| 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 batchonly replicaiton jobs,or job schedules can be added, modified,dropped or viewed through replicaiton SPscould not update the distribution database subscription table, the subscription status could not be changed.changed database context to 'master',(MSSQL SERVER error 22538) |
|
|
xiebo2010cx
Starting Member
4 Posts |
Posted - 2007-02-02 : 10:29:30
|
| publisher: 2005 Standard SP2 CTP |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-02-06 : 01:39:23
|
| You might have changed the job category because procedure checks the job category before dropping to make sure it is dropping jobs created by replication but not others...MohammedU |
|
|
|
|
|
|
|
|
Disable Repl error