Post reply

Is there any trace flag that I can use to monitor who is using the database often

  • August 12, 2008 at 3:15 pm

    #382229

    Hi guys:

    one of the SA wants me to investigate who is using the database often. At top of my head, I can not find a way to tell. Do you have any idea of this?

    Thanks in advance

  • August 12, 2008 at 3:20 pm

    #857064

    Have you considered profiler or a serverside trace? If you don't mind your error log growing significantly, you could also set the option to audit successful logins. (found under server properties-security)

    Of course, all of those require that users have their own individual logins. If they don't and there's a single application login, then it's going to be significantly harder.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 12, 2008 at 10:00 pm

    #857153

    Successful logins should be audited any how (it's the only way to gain non-repudiation), but a server side trace is best for this. There are 3rd party products that will also monitor at the network level and put shims in via an agent so a server side trace isn't necessary, but these aren't inexpensive choices.

    K. Brian Kelley
    @kbriankelley

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

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