Configuring SQL Database Mail

Here is a sample script for configuring database mail in the event you want to automate your SQL installs.      

Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

Views – 387

About Replication

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

Tearing down SQL Server Replication

I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…

Manually removing log-shipping

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…