Can't delete publication

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 1

SSCrazy Eights

Points: 9124

December 16, 2015 at 9:33 pm

try this

exec sp_removedbreplication N'sqlservername'

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

johnwalker10 (12/16/2015)
try this
exec sp_removedbreplication N'sqlservername'

The command executed successfully but it does not delete the publication.

Error: Could not find stored procedure. :ermm:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Which db are you running it against?

Also, what kind of replication is it?

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Distribution was not installed correctly.

I executed the following command and it removed the publication:

sp_removedbreplication @dbname = N'AdventureWorks2014Publisher'

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I also had to execute:

EXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1

GO

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Beatrix Kiddo (12/17/2015)
Which db are you running it against?
Also, what kind of replication is it?

Adventureworks2014

Transactional Pull

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/