Error 14005 Could Not Drop Publication
Contents |
additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those
Sp_droppublication
areas for which we need to provide more information. If the product or version you are looking for is not listed, you can use this search box to search TechNet, the Microsoft Knowledge Base, and TechNet Blogs for more information. Enter the product name, event source, and event ID. For example: Vista Application Error 1001.
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access the subscription on the subscriber does not exist Forums home Browse forums users FAQ Search how to drop publication in replication related threads Remove From My Forums Answered by: How do I
Could Not Delete The Subscription At Subscriber
remove a publication when the subscribers are already removed at the subscriber server? SQL Server > SQL Server http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL+Server&ProdVer=2000.80.760.0&EvtID=14005&EvtSrc=MSSQLServer Replication Question 0 Sign in to vote When I right click on the replication and choose delete I get: TITLE: Microsoft SQL Server Management Studio ------------------------------ Are you sure you want to delete publication "TS02-Repl" in database https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2bb69019-3a02-4573-b50f-1460aed825b4/how-do-i-remove-a-publication-when-the-subscribers-are-already-removed-at-the-subscriber-server?forum=sqlreplication "TS02"? All subscriptions to this publication will also be deleted except records at Subscriber which have to be deleted at Subscriber. 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=DeletePublicationConfirmation&LinkId=20476 ------------------------------ BUTTONS: &Yes &No ------------------------------ When i click Yes: TITLE: Microsoft SQL Server Management Studio ------------------------------ Could not delete publication 'TS02-Repl'. 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) ------------------------------ 'DPSS2K8SQL1' is not defined as a Subscriber for 'DPSS2K8SQLPROD1'. Could not update the distribution database subscription table. The subscription status could not be changed. Changed database context to 'TS02'. (Microsoft SQL Server, Error: 20032) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=20032&LinkId=20476 ------------------------------ BUTTONS: OK -----------------
New? Advanced Search Forum Miscellaneous General Database Discussions Cannot remove publication Error 14005 If this is your first visit, be sure to check out the http://forums.databasejournal.com/showthread.php?7214-Cannot-remove-publication-Error-14005 FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 1 of 1 Thread: Cannot remove publication Error 14005 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display could not Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-14-1998,07:32 AM #1 Robert Seese Guest Cannot remove publication Error 14005 I am having a problem removing a publication. I need to drop and recreate a table and I cannot remove a publication that it is included in. I also tried to just modify the publication and remove that one table. In both situations I does not exist get the same error in either case. Error 14005 [SQL Server] Unable to drop publication. A subscription exists on it. There are 2 subscribing servers. One of the subscribers is a remote distributor. Any Ideas would be greatly appricated. Thanks in advance, Robert Seese DBA RRS Police Records Management, INC Reply With Quote Quick Navigation General Database Discussions Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix Microsoft Access Microsoft SQL Server 2008 Microsoft SQL Server 2005 MDX and Analysis Services Reporting Services MS SQL Server 7/MS SQL Server 2000 MySQL Oracle PostgreSQL Sybase Miscellaneous General Database Discussions Ask an Expert Database Design Database Programming Database News and Announcements Structured Query Language (SQL) SQL Scripts Database Lounge Feedback Related Sites SQL Course SqlCredit « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is Off Forum Rules -- New Theme -- De