When I try to delete my Publication, It throws an error.

• anzz

  SSCertifiable

  Points: 5503

  More actions

  September 18, 2012 at 4:56 pm

  #261813

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Could not delete publication 'DB_Name'.

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.0.2100.60&EvtSrc=Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Replication.ReplicationMenuItem&EvtID=CantDeletePublication&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  'Distribution_Server' is not defined as a Subscriber for 'Server_Name'.

  Could not update the distribution database subscription table. The subscription status could not be changed.

  Changed database context to 'DB_Name'. (Microsoft SQL Server, Error: 20032)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=10.50.2796&EvtSrc=MSSQLServer&EvtID=20032&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------