Problem deleting publication

[Dave]

Hi All,

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 'sysschemaartic les'
Could not use view or function 'sysextendedart iclesview' because of
binding errors.

TIA
Dave

[Dave]

Re: Problem deleting publication


I 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_repli cation_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_removedbrepl ication got rid
of that.

Thanks,
Dave