Log Connections to SQL Instance
By Ginger Daniel | Helpful Scripts , Miscellaneous , SQL Administration , SQL Server
If you ever have a need to monitor connections to your SQL server, and any related information about the connections such as database, logins, etc., there are some DMVs that can give you tons of information. Previously you might have used the sys.sysprocesses table to derive much of this information, but this is being deprecated […]
Continue reading