Post reply

How to find out when if a table was accessed in SQLserver2005

  • August 12, 2008 at 2:51 pm

    #123016

    Is there a DM table in SQLserver2005 that I can query and find out if a table was accessed?

    or to run Profiler!!

    Thanks

  • August 12, 2008 at 3:23 pm

    #857065

    Selects or just data modifications? The latter, consider a trigger. For the former, you'll probably have to use profiler.

    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 13, 2008 at 2:12 pm

    #857708

    Yes, in the Profiler.

    -- Check Show all columns

    -- Check Security Audit > Audit Schema Object Access Event

    -- Make sure TextData is checked.

    -- Edit the Column Filters > TextData and add %YourTableToMonitor% in the Like area.

    I hope this helps!

    David

  • August 13, 2008 at 2:25 pm

    #857715

    Thanks

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

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