SQL Server Performance Forum – Threads Archive

sp_enumfullsubscribers

I’m executing:
sp_enumfullsubscribers @publication = ‘mypubsPublicationname’ on the mypubs database as user: SA Error:
Server: Msg 208, Level 16, State 1, Procedure sp_enumfullsubscribers, Line 36
Invalid object name ‘syspublications’.

---

What OS, SQL and Service Pack do you have?
Luis Martin
Moderator
SQL-Server-Performance.com

---

Win2k Pro SP4 SQL 2K sp3a

---

– Do you still see the distribution database in the database list?
Have you ever executed sp_removedbreplication on this server/database? Checkout for this object in publication database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>