How to Disable Publishing And Distribution?

Question

I'm getting the following error while disabling publishing and distribution. Plz, tell me how to do disable publishing and distribution?

SQL Server could not disable publishing and distribution on 'server'.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The Distributor has not been installed correctly. Could not disable database for publishing. Changed database context to 'master'. (Microsoft SQL Server, Error: 20029)

Answer 1

Take a look here: http://msdn.microsoft.com/en-us/library/ms147921.aspx

http://www.dbforums.com/microsoft-sql-server/388210-distributor-has-not-been-installed-correctly.html

Answer 2

I executed the following query

sp_removedbreplication @dbname = N'fxDb2'

It worked for me.. Thanks