Wednesday, March 20, 2013 9:36 PM
I want to setup an alert if a particular user accesses the database or server, I should get an email. The only issue is that this is user is a part of a SQL group. I also need to setup this for an individual user. So if you guys can help me in this would be great.
Thursday, March 21, 2013 8:48 AM
I can help you:-
You should find all you need in here to get started and then at least come back to us with a constructive question.
Thursday, March 21, 2013 8:55 AM
Logon trigger will help you in your case. However, for individual user, this might be wrong decision to mail trigger.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.