Click here to Skip to main content
15,844,498 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I have an application consisting of several classes to import data from the file. The import results in several tables getting updated/deleted/inserted. There are many of the stored procedures and triggers called to carry out this task. How do I have the activity monitored at the table level in the database? All I want to have a summary of tables affected by the import, the mode of insert/deletes/update (through triggers/stored procedures/application). Your solutions on this would be greatly helpful.

Thank you in advance.
Posted

1 solution

Your best option will be to use SQL Server Extended Events:
Using SQL Server 2008 Extended Events[^]

I've used this to capture rogue uses running queries they shouldn't be. As I don't know what all your application does, I can't tell you which events you will need, but the documentation is really good on this.
 
Share this answer
 
Comments
Sundar9057 2-Jul-15 13:58pm    
Thanks for the link. I'll take some time and go through.

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