September 24, 2021 at 3:01 pm
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 ?
September 25, 2021 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 27, 2021 at 8:38 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy