Post reply

How to chec out users logons

  • August 10, 2006 at 12:26 pm

    #62099

    Hi.

    I need to check out the user logons bue I can't use profiler.

    Does exist a way to do this??

  • August 10, 2006 at 1:56 pm

    #654421

    If you are wanting to view current users, use sp_who2.  If you are wanting an ongoing log of user connections, you will have to set your SQL Server's security audit level to capture what you want.  Keep in mind that this may have a significant impact on your SQL Server log files and that you need to evaluate your disk space.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 10, 2006 at 3:00 pm

    #654436

    Well, I just need to query the users sorting them by time of last logon.

    The log files aren't usefull for this.

    I was thinking in a trigger, but I don't know if you can create a "server" trigger.

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

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