Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Alert issue ---Please help

Respondida Alert issue ---Please help

  • Wednesday, March 20, 2013 9:36 PM
     
     
    Sign In to Vote
    0

    Friends,

    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.

     

All Replies

  • Thursday, March 21, 2013 8:48 AM
     
     
    Sign In to Vote
    0

    I can help you:-

    http://www.w3schools.com/sql/default.asp

    http://msdn.microsoft.com/en-us/library/ms130214(v=sql.105).aspx

    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
     
     Answered
    Sign In to Vote
    0

    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.

    • Proposed As Answer by skc_chat Thursday, March 21, 2013 9:35 AM
    • Marked As Answer by Iric WenModerator Thursday, March 28, 2013 8:57 AM
    •