how to get the recent query, executed on server

• taya_ronak

  SSC Rookie

  Points: 39

  More actions

  April 22, 2008 at 12:18 am

  #185635

  i want to get the query which is executed recently on sql server 2000. whts the method for this.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  April 22, 2008 at 12:33 am

  #805315

  sp_who2 will give you the details of the currently running processes. If you know the SPID of the process then you can run DBCC INPUTBUFFER(SPID) to know that command that was issued.

  e.g. DBCC INPUTBUFFER(53).

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Jaya Chitra

  SSCommitted

  Points: 1916

  More actions

  April 22, 2008 at 10:28 pm

  #805864

  Hi,

  When the query / stored procedure is executed along with the DBCC INPUTBUFFER(SPID), it is giving the query or the stored procedure.

  Is there any method to get the last executed query from a stored procedure?

  [font="Arial"]Nothing is impossible with Hard Work[/font]:)

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  April 22, 2008 at 10:34 pm

  #805866

  According to me sp_who2, DBCC INPUTBUFFER, querying the SYSPROCESSES table, Running a trace using SQL Profiler are only options to get the last executed query details.

  Regards,

  Pradeep

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga