InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 23:21:56 GMT20http://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxWanted to add my own, "Thanks Dude!" to this thread... I couldn't see this property setting any other way!Mon, 15 Nov 2010 10:54:11 GMTPhil Huffstatlerhttp://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxNoel... you just saved me from banging my head on my desk for another 3 hours.Fri, 20 Aug 2010 17:24:38 GMTA.J. Wilburhttp://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxHi Noel,I run into same issues. You mentioned “Make sure that you can cleanup the db from any replication settings”Can you explain in details please?Thanks,EdwinTue, 29 Dec 2009 09:23:45 GMTEd7http://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxIt helped me as well. Thanks for your postingTue, 27 Oct 2009 14:28:27 GMTrahmann60http://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxPerfect - did the job for me as well.:DSun, 08 Mar 2009 15:53:30 GMTbitfix99http://www.sqlservercentral.com/Forums/Topic613590-291-1.aspxSorry for not replying earlier , this did the trick:DWed, 10 Dec 2008 09:54:23 GMTThomas-428301http://www.sqlservercentral.com/Forums/Topic613590-291-1.aspx[quote][b]jude.pieries (12/4/2008)[/b][hr]- I get the following error when I attempt to create a publication from the wizard A exception occurred while attempting to execute a tsql statement or batch Can not find procedure “” Can not find procedure “” Change the database context to “XXX” . (Microsoft sql server :2812) - I tried creating the same from the following script and got an error message some related to the above exec sp_addpublication @publication = N'database', @description = N'Transactional publication of database ''database'' from Publisher ''Server\I01''.', @sync_method = N'concurrent', @retention = 0,@allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true',@compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true', @immediate_sync = N'true', @allow_sync_tran = N'false', @autogen_sync_procs = N'false', @allow_queued_tran = N'false', @allow_dts = N'false', @replicate_ddl = 1, @allow_initialize_from_backup = N'false', @enabled_for_p2p = N'false', @enabled_for_het_sub = N'false'The Error Msg 2812, Level 16, State 62, Procedure sp_MSrepl_addpublication, Line 1227Could not find stored procedure ''.- I tried removing the database from the publisher property list and got the following error The distributor has not been installed correctly, Could not disable the database for publishing , change the database context to “dabase name” error 20029” The last error message states that the Distributor DB is not setup correctly but there is no way to break the relationship between the Distributor DB and the attempted publication database(as I cant remove the publisher property from the database). I finally tried changing the system table "sysdatabases" value of "category" from 16 to 0 and that failes as well. I loged as DAC with single user mode and still failed to update the sysdatabases table( and yes I did sp_configure 'allow update',1 Reconfigure with Override) Please let me know what I can do to over come this situation Thanks in advance[/quote]First: Don't change "system tables" manually!On the Publisher (and on the Subscriber if you got it set up right at some point )Make sure that you can cleanup the db from any replication settings run :[code]exec sp_removedbreplication @dbname = 'dbname'[/code]On The Distributor (could be the same as the publisher) clean it using:[url=http://msdn.microsoft.com/en-us/library/ms147921.aspx]TSQL[/url]OR[url=http://msdn.microsoft.com/en-us/library/ms151759.aspx]SQL Server Management Studio[/url]Then you can start over.I hope this helps.Thu, 04 Dec 2008 11:44:26 GMTnoeldhttp://www.sqlservercentral.com/Forums/Topic613590-291-1.aspx- I get the following error when I attempt to create a publication from the wizard A exception occurred while attempting to execute a tsql statement or batch Can not find procedure “” Can not find procedure “” Change the database context to “XXX” . (Microsoft sql server :2812) - I tried creating the same from the following script and got an error message some related to the above exec sp_addpublication @publication = N'database', @description = N'Transactional publication of database ''database'' from Publisher ''Server\I01''.', @sync_method = N'concurrent', @retention = 0,@allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true',@compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true', @immediate_sync = N'true', @allow_sync_tran = N'false', @autogen_sync_procs = N'false', @allow_queued_tran = N'false', @allow_dts = N'false', @replicate_ddl = 1, @allow_initialize_from_backup = N'false', @enabled_for_p2p = N'false', @enabled_for_het_sub = N'false'The Error Msg 2812, Level 16, State 62, Procedure sp_MSrepl_addpublication, Line 1227Could not find stored procedure ''.- I tried removing the database from the publisher property list and got the following error The distributor has not been installed correctly, Could not disable the database for publishing , change the database context to “dabase name” error 20029” The last error message states that the Distributor DB is not setup correctly but there is no way to break the relationship between the Distributor DB and the attempted publication database(as I cant remove the publisher property from the database). I finally tried changing the system table "sysdatabases" value of "category" from 16 to 0 and that failes as well. I loged as DAC with single user mode and still failed to update the sysdatabases table( and yes I did sp_configure 'allow update',1 Reconfigure with Override) Please let me know what I can do to over come this situation Thanks in advanceThu, 04 Dec 2008 06:06:20 GMTjude.pieries