audit not show values from updates

• nosyspam

  Grasshopper

  Points: 12

  More actions

  July 8, 2010 at 1:27 pm

  #97231

  Hello,

  I configured my SQL Server 2000 with Audit C2 option and work fine. But I want see what happen in a UPDATE, I only saw:

  UPDATE field1=@1, field3=@2 FROM foo WHERE field2=@3

  however in SELECTs it is working fine:

  SELECT field1, field3 FROM foo WHERE field2=123

  why I can't see the values in UPDATES? such as:

  UPDATE field1='newvalue1', field3='newValue2' FROM foo WHERE field2='oldvalue1'

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 8, 2010 at 1:49 pm

  #1190476

  It depends on how the update is submitted. Lots of applications use parameters and an sp_executesql call.

  You might need to look at the activity from this connection before this statement.

• nosyspam

  Grasshopper

  Points: 12

  More actions

  July 9, 2010 at 2:58 pm

  #1191035

  Steve Jones - Editor (7/8/2010)

  ---

  It depends on how the update is submitted. Lots of applications use parameters and an sp_executesql call.

  I use pyodbc, I'll see how it work

  Steve Jones - Editor (7/8/2010)

  ---

  You might need to look at the activity from this connection before this statement.

  Who I can do it?

  Thanks