sql-server + replication + snippet

A straight forward approach to enabling of disabling the automatic replication of schema changes in transactional replication.

A script generator that produces the T-SQL needed to change the agent credentials for log reader, snapshot and distribution agents across a publication.

A last-resort script for removing a publisher and its distribution database from the distributor when normal unconfiguration fails.

The SQL Agent job definition that runs SendErrorAlerts every ten minutes to surface replication errors.

A trick for forcing the distribution agent through a snapshot cycle without actually delivering any data.

Two sp_changepublication calls that turn DDL (schema change) replication on or off for a publication.

A diagnostic query that finds replicated articles whose row filter procedures have gone missing from the publisher database.

How to use sp_browsereplcmds on the distribution database to inspect pending replication commands when diagnosing agent errors.

A batch of sp_changepublication calls that reset a publication to native sync with anonymous and immediate sync disabled.

The complete DDL for a ReplicationMonitor database that records replication throughput and errors over time.

A script generator that produces a batch of tablediff and sqlcmd commands to compare and repair every replicated table on a subscriber.

A step-by-step procedure for dropping a single article from a publication and re-adding it without forcing a full reinitialization.

A seven-step checklist for renaming a subscriber database and updating every replication table that references it.

A stored procedure that scrapes log reader agent history from every distributor database and records hourly command throughput for reporting.

A three-line recovery script that resets the log reader and flushes replication when pending reads must be abandoned.

A script that adds or removes the NOT FOR REPLICATION attribute on every identity column in the current database.

A detailed runbook for isolating and skipping a single bad transaction that has halted the log reader agent.

The SQL Agent job definition that records undistributed replication commands every fifteen minutes.

The SQL Agent job definition that runs the log reader and distribution command recording procedures every minute.