Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I see who has accessed the database, viewed the tables or executed SELECT, for SQL Server 2008 R2?

share|improve this question
What edition are you using? – Martin Smith Dec 17 '12 at 11:54
If your focus is on who (and not just that a table or database has been accessed), I'd suggest placing more emphasis on that in both the body and the title. Perhaps I was the only one who missed the mark, but it can never hurt to be more explicit. – Aaron Bertrand Dec 18 '12 at 18:07
up vote 3 down vote accepted

It sounds like what you're looking for is an audit. You can achieve this through the use of SQL Server Audit. With this tool, you will be able to audit Server and Database level actions and access.

To find out more information about how to use this tailored to your implementation, take a look at this BOL reference on SQL Server Audit.

This is available in Enterprise and Datacenter editions.

share|improve this answer
Gracias, I'll check this out. I see it can track SELECT, which is very important to me – Carlos Dec 18 '12 at 11:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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