• MarkusB (1/23/2009)


    In SQL 2005 SP2 or higher you can also create a Login trigger to log the logon event into a table.

    Why SP2? I thought that Login Triggers have been in SQL Server 2005 since RTM?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]