Changed database context to 'DatabaseName'. (Microsoft SQL Server, Error: 14046) Ok, so I try to drop the articles: EXEC sp_droparticle @publication = 'PublicationName', @article = N'all' and get this error: Invalidated sql-server-2008 share|improve this question asked Dec 11 '12 at 15:43 Pavel Gutin 93821339 1 This is probably a question for the DBA site, but it would help if you give If you find any you can try to remove it manually: exec sp_dropsubscription @publication = N'xxx', @subscriber = N'xxx', @destination_db = N'xxx', @article = N'all' -- And if that doesn't work Would presence of MANPADS ground the entire airline industry? Source
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed And there are plenty of search results for this error including this question; have you looked at them and do they match your situation and configuration in any way? –Pondlife Dec share|improve this answer answered Aug 21 '13 at 14:16 Hogan 7261912 22 Since some of us don't know how to do this offhand, here's the syntax: use [databasename] EXEC sp_changedbowner Changed database context to 'tass'. (Microsoft SQL Server, Error: 15517) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=15517&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I have tried to delete it by right clicking and delete. http://dba.stackexchange.com/questions/135745/how-to-fix-a-messed-up-replication-on-ms-sql-server
I was able to drop but got error while restoring. It doesn't have to be on the same server as the publication database or the subscription database.Tara Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL You cannot send private messages. How To Disable Replication In Sql Server 2008 R2 Longer version: A workmate had a go at trying to fix it.
Here is what I have asked them to perform and update me with the result. How To Remove Replication In Sql Server 2008 R2 So I tried the sp_droppublication command. Wednesday, December 18, 2013 7:30 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. Post navigation Previous Previous post: Remove Replication from SQL Server 2012Next Next post: Sys.dm_server_services – new DMV in SQL Server 2012 Search for: Search Archives November 2016(1) June 2013(1) May 2013(1)
He is a author of many technical articles on Microsoft Technology and authored a book of SQL Server 2012 Performance Tuning cookbook. Sql Server Error 15517 Replication he comes across the following error: [sourcecode language="sql"]TITLE: Microsoft SQL Server Management Studio -------------------- Could not delete publication ‘AdvertureWorks2012AddressObjects'. share|improve this answer answered Apr 19 at 20:42 TallGuy 1465 Great read for newbies. So I logged in as SA right clicked the database ->properties->files->…(2nd setting) and assigned the owner to SA.
Now its sorted! http://blog.extreme-advice.com/2013/04/09/error-fix-replication-subscriber-does-not-exist-on-the-server-anymore/ You cannot delete other topics. Cannot Drop The Publication Because At Least One Subscription Exists For This Publication View all posts by Riteshshah Author RiteshshahPosted on April 9, 2013April 8, 2013Categories replication, sql serverTags Force remove replication, remove publication, remove subscriber, replication 1 thought on “Error Fix – Replication Sp_removedbreplication SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered!
Anyway, when you checked the subscribers, did you also check that section on the publisher server to make sure there was nothing else listed? TSQL Copy DECLARE @publication AS sysname DECLARE @publicationDB AS sysname SET @publication = N'AdvWorksSalesOrdersMerge' SET @publicationDB = N'AdventureWorks2008R2' -- Remove the merge publication. What's the correct term to describe baby food? Assuming the database restore would break the replication, I tried to delete the replication and re-create it (we have a script to re-create it from scratch).
SQL Server generated the script for me using the replication generate script wizard. Sp_dropsubscription Not the answer you're looking for? You cannot edit other topics.
A published paper stole my unpublished results from a science fair Is scroll within a card good or bad? (In desktop) Parents disagree on type of music for toddler's listening How But maybe if you deleted the rows in the publication database that start with MS. USE master EXEC sp_replicationdboption @dbname = @publicationDB, @optname = N'merge publish', @value = N'false' GO See AlsoTasksHow to: Delete a Publication (RMO Programming)How to: Delete a Publication (SQL Server Management Studio)ConceptsReplication Sp_subscription_cleanup Do SSDs reduce the usefulness of Databases The difference between 'ping' and 'wget' in relation to hostname resolution Law case title convention: Why sometimes not "Plaintiff v.
How can I verify what the distribution is called and that it exists? I refreshed the Local Publications node in SSMS and sure enough it had gone. We appreciate your feedback. Output the first position in your program for each input character How to include module's CSS in CMS pages with module block Shortest auto-destructive loop Why is credit card information not
A subscription exists on it. Monday, August 09, 2010 3:04 AM Reply | Quote 0 Sign in to vote Thanks! How to include module's CSS in CMS pages with module block Why is credit card information not stolen more often? I've always done a push subscription, never a pull one.