I have a problem, a user deleted some tables from a couple db's dealing
with replication. I now get this error on those db's.
The process could not execute 'sp_repldone/sp_replcounters on
servername
I have deleted one of the database's and neither are listed under
publications but they still show up under replication monitor.
Any ideas on how to delete them would be great. When I try I get
Error 208: Invalid object name 'sysarticles'
Invalid object name 'sysschemaarticles'
Could not use view or function 'sysextendedarticlesview' because of
binding errors.
TIA
DaveI figured it out, hope this helps someone.
I went into the distribution db and went thru every table and removed
any reference to the databases that were giving me problems. That got
rid of the ghost entries in the replication monitor folder. Oddly I
still had the red X's on the folders them selves but nothing under the
folders had X's and a refresh didnt make them go away. A
sp_MSload_replication_status did though.
Now just the database of the two that were needed still had the repl
hand icon on the database. The good old sp_removedbreplication got rid
of that.
Thanks,
Dave
No comments:
Post a Comment