1

We have a table that has a very long update process that I think was from a no longer used program. No one can seem to tell me if anyone still uses it or not.

What is the best way to log which users read from the table? Build an audit or can I dig through a system log somewhere to find any user that might have read from it?

Thank you.

1 Answer 1

3

SQL Server has a built in Audit feature that can be used to track this for you. Here is an article called Auditing SELECT statements in SQL Server 2008 that walks through how you can accomplish it. (It's helpful despite being a little dated.)

Aside from that, there's always the scream test. 🙃 Just rename the table and see what breaks and who complains.

Additionally, you might be interested in knowing what else may be consuming that Table which you can easily do via SSMS by right clicking it and clicking on View Dependencies. Here's some Microsoft docs about that as well. Also, RedGate has a free and helpful tool called SQL Search that can help you find the references as well.

2
  • 1
    Thanks. I was a fan of the rename it and see who screams, but apparently the powers that be think "it might cause problems". Ruined a lot of fun I think.
    – Toolman21
    Sep 2, 2021 at 19:36
  • @Toolman21 lol I get it, we can't always have all the fun I guess. Best of luck!
    – J.D.
    Sep 3, 2021 at 0:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.