I need to keep an easily accessible record of user id's and time whenever someone accesses a particular SQL Server 2005 table. I have used triggers to accomplish this in the past, to record edits, deletes and inserts and write an entry to a log table that I created. Is there a way to record a SELECT operation? Basically I need to know WHO is accessing the table and when.
In my particular situation, I'm not concerned with anyone trying to access the table through a view or stored procedure (but I'd be delighted if I knew how to monitor those operations as well).