SQL Check Database Replication Status | VirtualSpecies

SQL Check Database Replication Status

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.

1
2
EXECUTE sys.sp_helpreplicationdb @dbname = [YourDBName], -- sysname
                                 @type = pub    -- sysname

No comments:

Post a Comment