Capture Tables Updates-Add , updare and delete record) when Sp executed
-
When i run a stored procedure, i would like to capture all the Database updates with table name and preferably values updated.
What tool i can use ?
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
This is typically something handled by creating a trigger on the relevant tables, and is "on" all the time. When you need to capture the actions of only a specific stored procedure, it would need to either be coded in the stored procedure or might need a slightly different kind of trigger, and I forget what they call them.... is either DDL or DML, or possibly Database. Someone else likely remembers those details far better than I do.
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply