Finding source of a query

• webrunner

  SSC-Dedicated

  Points: 31866

  More actions

  June 23, 2008 at 2:23 pm

  #381299

  Hello,

  Does anyone know how I might trace the source of a query in SQL Server 2000 Standard Edition? I'm trying to find out the source a query against data on our system.

  I have a database in Simple recovery model, and auditing is not turned on, and no profile trace was running. Basically, I think I'm out of luck on this one.

  But my questions are:

  1. Is there any way I might be able to see who ran a query and when?

  2. What can I do going forward to best track activity?

  Thanks for any help,

  webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Wildcat

  SSCarpal Tunnel

  Points: 4774

  More actions

  June 23, 2008 at 3:04 pm

  #833034

  I use profiler or system sprocs to trace those kinds of activities.:hehe: