How to remove unused publications (replication)

• mariobehring

  Mr or Mrs. 500

  Points: 516

  More actions

  January 19, 2012 at 11:37 am

  #249850

  Hi list,

  I have some old replications on my prodution server that no longer exists...I mean, the subscriber server was formated and SQL Server was installed from scratch.

  I cannot delete these local publications..I keep getting the same error for all of them:

  TITLE: Microsoft SQL Server Management Studio

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

  Could not delete publication 'rep_corporerm'.

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&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)

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

  Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

  Changed database context to 'CorporeRM'. (Microsoft SQL Server, Error: 15517)

  Is there any workaround to delete these publications for good?

  Regards,

  Mario

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  January 19, 2012 at 12:23 pm

  #1436123

  It sounds as though you have some permissions issue with the older publications.

  If you log in as "sa", can you do a sp_droppublication on the item?

  http://technet.microsoft.com/en-us/library/ms188363.aspx

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  January 20, 2012 at 3:46 am

  #1436354

  You can try one of these and reset up replication afterwards.

  sp_removedbreplication

  sp_replicationdboption @dbname = N'<Publication database name>', @optname = N'publish', @value = N'false'