Post reply

log access from users

  • May 24, 2006 at 11:54 am

    #113134

    I have been asked at work if SQL Server can log access from users. For example if I was asked to say who had logged onto a certain database over the last few days would I be able to present a complete report of logging in and logging out for who and when?

    I know sp_who gives some of this info but I don't get all I need

    Can anyone help me with this, please?

    Monica

  • May 24, 2006 at 12:15 pm

    #639876

    There's a good article on this:

    http://www.sqlservercentral.com/columnists/hji/trace.asp

  • May 30, 2006 at 7:41 am

    #640675

    Hello Aaron,

    Thank you very much for your suggestion I read the article and I found all I needed.

    Monica

  • May 31, 2006 at 4:16 am

    #640860

    Hello,

    I have one more question. The article was good, I made changes to the script so I could trace what I needed to. One more thing, I am trying to filter not just by application name (column 10) but also by the name of the application so I will get activity for that particular app and I am not having much luck. I am poblably missing something simple but...could you help please?

    Thanks a lot

    Monica

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

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