Post reply

Who is using a specific table

  • March 28, 2016 at 1:30 pm

    #399931

    Hi,

    I am trying to find a way to track who is querying a specific table. Is there a way to find it? I am able to find the last_user_seek, but I cant find who and form where?

    Any help will be appreciated.

    Thanks,

  • March 28, 2016 at 2:21 pm

    #1868075

    Have you tried using extended events? Or are you looking for historical information that a new extended events session wouldn't catch?

  • March 29, 2016 at 3:25 am

    #1868160

    You'll need something like extended events or SQLAudit for that.

    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

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

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