find user_id of a system through which odbc has been used

• DURGESH-769360

  SSC Eights!

  Points: 968

  More actions

  March 29, 2009 at 10:58 pm

  #73623

  hi all,

  I want to read user_id of the system through which odbc has been used. The user of database has use ODBC to make update in Sql server through Ms-Access 03

  Thanks in Advance

  Regards

  Durgesh

• cloud-754230

  SSC Veteran

  Points: 219

  More actions

  April 1, 2009 at 5:18 am

  #969732

  Use SQL Profiler to track SQL events Login/Logout or even Prepare SQL stratements.

  be careful to use the filter to limit the data returned or you'll have too much information to be use.

  Once you know what you're tracking and have limited you could leave it running for a predetermined period