To track changes from a stored procedure:

• Output Parameters: Use output parameters to capture the number of affected rows for inserts, updates, and deletes.
• Audit Tables: Store changes in separate...

• This reply was modified 1 year, 3 months ago by  Steve Jones - SSC Editor.