Disabling Repl error (22538)

Posted - 02/01/2007 : 22:35:02

---

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 22538)

Please help

publisher: 2005 Standard SP2 CTP

Try dropping the subscriptions before trying to disable publishing and distribution. If you still have issues cleaning up, try using sp_removedbreplication at the subscriber and publisher. You can get more information on sp_removedbreplication from http://msdn2.microsoft.com/en-us/library/ms188734.aspx

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Tom, thanks,

Could not be able to drop subscriptions, getting the same error.

Trying to use sp_removedbreplication, it works at subscribers side, while does not work at publisher side, getting the error:

Msg 22538, Level 16, State 1, Procedure sp_MSrepl_check_job_access, Line 155

Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.