Is there a command history in SQL Query Analyzer?

[DWArchitect]

Hi,

I am using Query Analyzer to submit ad hoc queries to SQL Server. However, I have not been able to find out how to recall SQL commands that I have entered. Is there no history of commands.

I don't want to have to retype all of my statements.

It seems incredible that there is none, but I have not been able to find any help on this.

Thanks,
DWArchitect

 

[JamesLean]

No, there is no query history kept by default. If you write queries in QA then you can save them as scripts. If you don't save them and close the connection then they are lost.

--James