SQL Server Performance Forum – Threads Archive

Receive mail when specific user connects

Hi,
I want to receive a mail when a specific user connects.
How can this be done best? Raise an alert? How?
Btw, the ‘Login auditing’ is set to ‘Failed logins only’.
Suggestions are very welcome!
Cheers,
E

You might take or look at Notification services in this case to get such arrangement information.
http://www.15seconds.com/issue/040902.htm fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Or you could look at login triggers in SQL 2005 SP2.

Check the examples of login triggers in the following articles.. http://sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx
http://www.sqlservercentral.com/columnists/FVandeputte/sqlserver2005logontriggers.asp MohammedU.
Moderator
SQL-Server-Performance.com

]]>