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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply