Change Data Capture - How to track user who changed the data

• manohar.vikram

  SSC Rookie

  Points: 36

  More actions

  July 1, 2011 at 1:00 am

  #238955

  Using change data capture feature can we also capture information of who(Loginname) has updated the particulur table / changed some data?

• mandaralawani

  SSC-Addicted

  Points: 489

  More actions

  July 1, 2011 at 2:27 am

  #1346906

  There is no direct way to do this ...

  however you can build a custom solution as shown here:

  http://weblogs.sqlteam.com/derekc/archive/2008/01/28/60469.aspx

• manohar.vikram

  SSC Rookie

  Points: 36

  More actions

  July 3, 2011 at 10:06 pm

  #1347616

  Thanks Mandar for sharing the link.