Who's been selecting data from my table?!

  • Profiler/SQL Trace is really your only choice here. Set up a trace to capture stuff hitting the table.

  • Thanks Steve,

    Do you think I would be better with standard auditing?

    P

  • What is standard auditing?

    In 2000, there isn't any good way to do this. Triggers won't help. Instead you'd have to set up a trace that would capture SELECTs against this table. The filtering in 2000's trace can be flaky, so you might need to capture everything, then delete out that data not referencing your table.

    I'd log this to a table in a separate database, trim it on occassion, and use that for your auditing.

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

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