2

I deleted all the publications and subscriptions related to the database 'test'. All I have now are the publications and subscriptions related to other databases in the server. Still, It says "Cannot drop the database 'test' because it is being used for replication."

For evidence, These are the current publications related to another database "Computers": enter image description here

manikanta nvsr
  • 487
  • 5
  • 20

1 Answers1

6

The message stating "Cannot drop the database 'test' because it is being used for replication." is due to because the database is still marked as a publisher.

select * from sys.databases where is_published = 1

Once you remove all the publications, can you unmark the database as the publisher via sp_removedbreplication https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-removedbreplication-transact-sql?view=sql-server-ver15

Jeff
  • 76
  • 2