Post reply

Invalid object name ''syspublications''

  • August 22, 2005 at 12:49 pm

    #363476

    Hello everyone,

    I just setup snapshot replication on one of my database servers and when I attempt to run the snapshot, I receive the Error 208: Invalid object name 'syspublications'.  I checked the publications database for this system table and it DOES exist.  The account that the snapshot agent is running on has access to the syspublications table.

    With that, I'm at a loss as to why I'm getting this error.  If anyone has any ideas, it would be much appreciated.

    Thank you for your help.

    Pete..

    Peter M. Florenzano

    Database Administrator

  • August 22, 2005 at 1:19 pm

    #584031

    After a little persistance on my part and with the use of SQL Profiler, I discovered that there was a missing stored procedure named  sp_MSestimatesnapshotworkload. 

    Pete

    Peter M. Florenzano

    Database Administrator

  • August 24, 2005 at 5:26 am

    #584537

    You will likely find other missing stored procedures as well. It sounds like your latest sp did not apply correctly. You will need to reapply it and all subsequent hot fixes.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

  • August 24, 2005 at 7:04 am

    #584563

    Very true Hilary.  I will check the other stored procedure to make sure they are in place.

    Thanks!

    Peter M. Florenzano

    Database Administrator

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply