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