How would I be able to capture sessions who modify a table with the details modified in the table

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 10, 2015 at 2:23 pm

  #296872

  Hi Folks,

  I created am inventory table with few columns say, Servername, version, patching details, etc

  I want a tracking of the table.

  Let's say people are asked to modify the base table and I want a complete capture of the details modified and the session of the user ( ) who (system_user) is actually modifying the details.

  Thanks

  Thanks.

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  April 11, 2015 at 4:36 am

  #1790342

  You're describing Change Data Capture.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning