InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 23:28:13 GMT20http://www.sqlservercentral.com/Forums/Topic546850-7-1.aspxFirst off, I'll say that I'm not sure who did what to this server before I got called about this - all I know is they were trying to remove transactional replication. I'm trying to run sp_removedbreplication on one of our databases and I keep getting this error back..Net SqlClient Data Provider: Msg 208, Level 16, State 1, Procedure sp_MSpublishdb, Line 110Invalid object name 'syssubscriptions'.I've tracked this down - I think - to this area of sp_MSpublishdb EXEC @retcode = dbo.sp_dropsubscription @publication = 'all', @article = 'all', @subscriber = 'all', @ignore_distributor = @ignore_distributorso I tried running sp_dropsubscription myself with @ignore_distributor = 1And I think that is failing here DECLARE hCdrop_subscription1 CURSOR LOCAL FAST_FORWARD FOR SELECT DISTINCT srvname FROM master..sysservers a, syssubscriptions b WHERE srvstatus & @subscriber_bit <> 0 AND a.srvid = b.srvidNow when I first started looking at this, syssubscriptions was gone. I had a an old backup of the database though with that table in there, no rows but the structure was right. So I created the table and am still getting this message that Syssubscriptions is missing. I can run this SELECT DISTINCT srvname FROM master..sysservers a, syssubscriptions b WHERE srvstatus & @subscriber_bit <> 0 AND a.srvid = b.srvidjust fine. I get no rows back, but it runs no problem.Has anyone run into this?Tue, 05 Aug 2008 09:46:59 GMTmike-306849