SQL Server Education (by the geeks, for the geeks)
Here’s a T-SQL to send automated email alerts. whenever a SQL Server Monitoring Transaction Log size exceeds a specified threshold. SET NOCOUNT ON DECLARE @threshold int=5 — step 1: Create temp …
SQL Server Monitoring Transaction Log size with Email Alerts Read MoreRecently, I came across a situation where on one of the server I manage, there was a full text query which took hours to complete and many times caused overall system …
SQL Server Configure alerts for long running queries Read MoreOne fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. This Bug\Problem is applicable to SQLServer 2008 SP1, …
SQL Server DB Mail Account Creation Failed – A Bug Read More