Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

share|improve this question
3  
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.