sp_enumfullsubscribers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.