History of SQL Queries

• sumit-679660

  Say Hey Kid

  Points: 704

  More actions

  October 9, 2008 at 8:44 am

  #191911

  Hi,

  Is it possible in query analyzer to view the last 10 (or 30) SQL commands I ran (executed/failed) ?

  I am thinking on the lines of Teradata query history window.

  Thanks.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 9, 2008 at 12:24 pm

  #883082

  There isn't any query history function in Query Analyzer.

  Greg

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  October 10, 2008 at 12:27 pm

  #883592

  http://www.ssmstoolspack.com/

  I don't know if it supports 2000 though, it works for 2005/2008

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005