 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / March 2006Unable to Delete a Publication.
I need to delete a transactional publication (no subscribers) and the associated database. I have tried to use sp_droppublication and sp_replicationdboption without success and I believe that this is due to some of the conflict tables being deleted from the published database. Is there any way I can forcibly delete this publication. Many thanks David hi , use enterprise manager , >I need to delete a transactional publication (no subscribers) and the > associated database. I have tried to use sp_droppublication and [quoted text clipped - 6 lines] > Many thanks > David Thank you but I have tried that same result. > hi , > use enterprise manager , [quoted text clipped - 9 lines] > > Many thanks > > David Can you tell us the exact error you are getting in deleting that publication... > Thank you but I have tried that same result. > [quoted text clipped - 11 lines] > > > Many thanks > > > David This is the error, there are up to 42 of these in total... Msg 208, Level 16, State 1, Procedure sp_MSrepl_droparticle, Line 793 Invalid object name 'MSpub_identity_range'. Msg 266, Level 16, State 2, Procedure sp_MSrepl_droparticle, Line 793 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1. ...I can confirm that some, if not all, of the system tables that replication creates have been deleted. I am not concerned if the publication database needs to be dropped. Thanks again. > Can you tell us the exact error you are getting in deleting that > publication... [quoted text clipped - 15 lines] > > > > Many thanks > > > > David David you can also try this option. use master go update sysdatabases set category = 0 where name = <your publication you want to drop> make sure the option to make adhoc changes to system tables in turned on. > This is the error, there are up to 42 of these in total... > [quoted text clipped - 29 lines] > > > > > Many thanks > > > > > David David, you can also try this option use master go update sysdatabases set category = 0 where name = <the publisher db you want to drop> make sure you set the allow modifications to be made directly to the system catalogs option turned on. hope this helps. > This is the error, there are up to 42 of these in total... > [quoted text clipped - 29 lines] > > > > > Many thanks > > > > > David Thanks but I thought that updates to the system catalogues under SQL Server 2005 were prohibited. > David, > you can also try this option [quoted text clipped - 41 lines] > > > > > > Many thanks > > > > > > David I didn't know you had SQL 2005. But you can still do it using the DAC. sqlcmd -S<sql2005servername> -E<trustedConnection> or you can use -U , -P , -A (to open the DAC) you can enable the option to enable system catalogs using the sp_configure option. > Thanks but I thought that updates to the system catalogues under SQL Server > 2005 were prohibited. [quoted text clipped - 44 lines] > > > > > > > Many thanks > > > > > > > David |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.