Click here to Skip to main content
15,938,218 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i have database consists of many tables in sql 2008, i want if any one performs select query to view table content need to audit that time & table name.


when ever select query hits on table of database, in audit table need to insert audit record consists table name & time details

i want to do this requirements with sql commands in windows azure

i can achieve this requirement with c# coding, but i want to do this in sql server only

can any one help me how to do this

thanks
Posted
Updated 3-Jul-13 3:13am
v2

1 solution

You can get this information using the Management Studio - here's just one article on auditing select statements[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900