Script to Remove Replication SQL Server

--Set deadlock priority to high to make sure the script is not stopped due to deadlock

SET DEADLOCK_PRIORITY HIGH

--<numeric-priority> ::= { -10 | -9 | -8 | ... | 0 | ... | 8 | 9 | 10 }

sp_removedbreplication @dbname = 'db_name', @type = 'Tran'

--Note: @Type='Tran' is for transactional replication.

Recent Posts

--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...