Is there a way to know which user inserted which data

• ltoso

  SSC Eights!

  Points: 852

  More actions

  July 10, 2008 at 2:32 pm

  #122402

  Hi,

  we are using sql server express 2005 is there a way in it to know which user entered what data and which user performed what query.

  please recommend

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  July 10, 2008 at 6:21 pm

  #841185

  For DML transactions, hope there is nothing unless you create some user defined triggers with Audit tables.

  Thanks
  Jay
  http://www.sqldbops.com