• Adam Thurgar

Script out database mail settings


Whilst building a new SQL Server I wanted to make sure that the database mail settings where the same as the previous servers. Even if I had all the information there is still the chance that I could make a mistake or a typo. Luckily I found this script that will script out the database mail settings, which you can then run to configure database mail consistently.

Follow this link for the script.

https://gallery.technet.microsoft.com/scriptcenter/Script-to-Scipt-out-14a19eda


15 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t