Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to audit Select sentences in a table

Author  Topic 

trallador
Starting Member

13 Posts

Posted - 2013-12-30 : 06:32:34
I have a problem with a table that i need to audit the "SELECT" sentences. I need to log the user and the date of access.

Its a low traffic table so the render of sql server would not be really affected.
I used to find a solution with triggers but not affects SELECTs.

Anybody knows how i can do that? Thx for advance.
   

- Advertisement -