Post reply

Setting up Login alerts

  • March 23, 2009 at 4:05 pm

    #198338

    Question regarding setting up alerts for login attempts. If you wanted to create an alert anytime a account successfull logs in. Do you need to setup Login Auditing to audit successful logins?

    Thanks.

    Ryan

  • March 23, 2009 at 6:20 pm

    #964915

    Check out ..

    http://www.sqlservercentral.com/articles/SQLServerCentral/sqlserver2005logontriggers/2366/

    This shows how to use notification services to setup login alerts/auditing.

    Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply