I setup SQL Server Alerts to send me emails whenever certain events (by severity) occur. Below is an example of en email I received for a "
014 - Insufficient Permission" severity event of
SQL Server event alert." I looked in the Error Log as well, but no more detailed information can be found.
DATE/TIME: 1/9/2013 3:38:01 PM DESCRIPTION: Login failed for user 'DOMAIN\username'. [CLIENT: <local machine>] COMMENT: (None) JOB RUN: (None)
I want to increase the level of detail provided in these alerts to make it easier to debug and resolve issues. How can I accomplish this?