Database Replication

Unmark Replication

Check publisher database

select * from sys.databases where is_published = 1;

Unmark publisher

EXEC sp_removedbreplication 'database_name';