Monitor Table Activities

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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 2-Jul-15 5:48am

Sundar9057

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

virusstorm · Answer 1 · 2015-07-02T06:28:00

Solution 1

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.

Posted 2-Jul-15 6:28am

virusstorm

Comments

Sundar9057 2-Jul-15 13:58pm

Thanks for the link. I'll take some time and go through.