InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:16:01 GMT20http://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspxThank you, SSC Veteran for your co-operation.Thu, 08 Nov 2012 04:05:03 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspxits working fine for me in SQL serevr 2008 R2 or else another option is[code="other"]ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO saGO [/code]Thu, 08 Nov 2012 03:30:22 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspx[quote]Hi thats just a informational message ..I think link below will help you more [url]http://support.microsoft.com/kb/913423/en-us[/url][/quote]I have gone through the above link. But I am using SQL Server 2008 R2. Will it work?Thank You.Thu, 08 Nov 2012 01:57:26 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspx[quote]pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"[/quote]Hi thats just a informational message ..I think link below will help you more [url]http://support.microsoft.com/kb/913423/en-us[/url]Thu, 08 Nov 2012 00:47:09 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspx[quote][b]sanket kokane (11/7/2012)[/b][hr]please check if there any db_owner for your database used in replication.if there is no change it to SA or any other active loginuse Yourdatabasegosp_changedbowner 'sa'[/quote]pls can u tell me the meaning of this line "Changed database context to 'master'. (Microsoft SQL Server, Error: 15517)"Thu, 08 Nov 2012 00:19:16 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspxplease check if there any db_owner for your database used in replication.if there is no change it to SA or any other active loginuse Yourdatabasegosp_changedbowner 'sa'Wed, 07 Nov 2012 23:49:33 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1382273-391-1.aspxDear,I am trying to disable my distributor and publisher in replication but I am getting the following error message.[[i]TITLE: Microsoft.SqlServer.ConnectionInfo------------------------------SQL Server could not disable publishing and distribution on 'SERVER1'.------------------------------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 'master'. (Microsoft SQL Server, Error: 15517)[/i]]please help me to sort out the problem.Regards,AkbarWed, 07 Nov 2012 23:42:43 GMTshohelr2003