Month: August 2022

Script to consolidate SQL Server agent logs

Problem: How can I view all SQL Server agent logs at-one-time without querying each individual log on its own? Solution: The answer is to put this data into a single table allowing you to better query this information based on your individual needs. I’ve given a possible solution with the following T-SQL script. Let me …

Script to consolidate SQL Server agent logs Read More »

Script to identify unused SQL Server database mail accounts

Background: Following in-step with my previous blog posts, you will know that I like to keep my SQL instances as free from clutter as possible. I provide a script below that will return all database mail accounts not currently being used by any database mail profile on the current instance. Having this list allows you …

Script to identify unused SQL Server database mail accounts Read More »