SQL alerts

From: Brucee (Brucee_at_discussions.microsoft.com)
Date: 06/29/04


Date: Mon, 28 Jun 2004 15:25:01 -0700

I am able to get an alert working for "all databases insufficient permissions" but the message does not tell me who tried to logon or from where. I get alerts from time to time for failed sa login but I cannot find out who is trying to use it from the alert.

I have tried to set the above alert on each database but it will not work.

Any ideas will be much appriciated

Cheers Bruce