Post reply

Error 208: Invalid object name ''msdb.dbo.MSdistpublishers''

  • July 10, 2017 at 6:18 am

    This was removed by the editor as SPAM

  • January 9, 2018 at 4:21 am

    #1975047

    starsthescqw - Monday, January 25, 2010 11:55 AM

    Kumaran Govender (10/29/2008)

    Hi Guys,I know that is is an old topic, but the net does not seem to come up with an easy solution. After playing around for a bit I managed to fix it, here is the soltion:-After ensuring that "SELECT @@SERVERNAME" is NOT NULL ensure that the '[MSdistributiondbs]' and '[MSdistpublishers] ' tables are NOT present in the msdb database. If the are remove then and use the code below to add them back. Once this is done the "Error 208:..." will disappear and you can proceed in setting up your replication.Good Luck :DUSE msdbGOCREATE TABLE [MSdistributiondbs] ([name] [sysname] NOT NULL ,[min_distretention] [int] NOT NULL ,[max_distretention] [int] NOT NULL ,[history_retention] [int] NOT NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[MSdistpublishers] ([name] [sysname] NOT NULL ,[distribution_db] [sysname] NOT NULL ,[working_directory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,[security_mode] [int] NOT NULL ,[login] [sysname] NOT NULL ,[password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[active] [bit] NOT NULL ,[trusted] [bit] NOT NULL ,[thirdparty_flag] [bit] NOT NULL ) ON [PRIMARY]GO

    Good solution, this fixed my issue immediately.  Thank you so much..

  • January 9, 2018 at 5:07 am

    #1975050

    toheebbellob01 - Tuesday, January 9, 2018 4:21 AM

    starsthescqw - Monday, January 25, 2010 11:55 AM

    Kumaran Govender (10/29/2008)

    Hi Guys,I know that is is an old topic, but the net does not seem to come up with an easy solution. After playing around for a bit I managed to fix it, here is the soltion:-After ensuring that "SELECT @@SERVERNAME" is NOT NULL ensure that the '[MSdistributiondbs]' and '[MSdistpublishers] ' tables are NOT present in the msdb database. If the are remove then and use the code below to add them back. Once this is done the "Error 208:..." will disappear and you can proceed in setting up your replication.Good Luck :DUSE msdbGOCREATE TABLE [MSdistributiondbs] ([name] [sysname] NOT NULL ,[min_distretention] [int] NOT NULL ,[max_distretention] [int] NOT NULL ,[history_retention] [int] NOT NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[MSdistpublishers] ([name] [sysname] NOT NULL ,[distribution_db] [sysname] NOT NULL ,[working_directory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,[security_mode] [int] NOT NULL ,[login] [sysname] NOT NULL ,[password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[active] [bit] NOT NULL ,[trusted] [bit] NOT NULL ,[thirdparty_flag] [bit] NOT NULL ) ON [PRIMARY]GO

    Good solution, this fixed my issue immediately.  Thank you so much..

    Good to see my solution still helping 10 years after I posted it...

Viewing 3 posts - 16 through 17 (of 17 total)

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