How to Properly shutdown and disassemble SQL Database Replication
To properly clean up replication, follow below steps :


Open SSMS --> Local Publications --> Expand Publication -->






Use sp_removedbreplication to remove replication bit set on database.



Another Method is script our the DROP or disable the components by right click on publication and then run that script using SSMS.