When I try to drop the XXX database SQLServer returns me this error message:
Server: Msg 3724, Level 16, State 3, Line 1
Cannot drop the database XXX because it is being used for replication.
I've also tried to execute the following code but nothing has changed.
exec sp_removedbreplication 'XXX'
exec sp_dboption 'XXX','published',false
exec sp_dboption 'XXX','merge publish',false
The XXX DB is a restore of "Distribution" database of a Production Server that is a publication server!
Someone can help me?
Thanks for all suggestions!!!