A database can not be dropped if there is replication enabled for it. We can use the below stored procedure to check whether a database has a Publisher that enabled for replication.
EXECUTEsys.sp_helpreplicationdb @dbname = [YourDBName],-- sysname@type = pub-- sysname
No comments:
Post a Comment