Home Forums SQL Server 7,2000 Replication Error 208: Invalid object name ''msdb.dbo.MSdistpublishers'' RE: Error 208: Invalid object name ''msdb.dbo.MSdistpublishers''

  • hi guys.. sorry if my english is not so good..

    im just reading this post because im having the same issue..

    i getting an error 208 trying to create a publication, after several tryes of creating the publication (Transactional replication) i got the same error.. but with a little diference 'Invalid object name dbo.syspublications' --> I don't know in what database is that object..

    Steps done in several tries

    MSDB DATABASE --> Recreation (Cheked)

    @@servername --> not null (Cheked)

    Distribution database --> RECREATION (Checked)

    Linked server --> Server is connected to a linkin server (what is going to be the subscriber server)--(CHECKED)

    i just want to know if it is better droping all the information of replication in the server.. and just start over, because getting the same error 'Invalid object name dbo.syspublications'

    Server information: Sql Server 2005 SP3

    Transactional replication (Creating Publication)

    thanks and waiting for some information to solve this!