Hi All:
   Is it possible to view the query history in SQL Server Management Studio
- I mean the list of queries that were executed from the management Studio,
the start time, end time etc?

Thanks in Advance,
Prasanna R

Prasanna (Prasa***@discussions.microsoft.com) writes:
There is no such feature.

But if you are foreseeing you can set up a trace in Profiler, or
server-side.

It's also possible to find statements in the query cache, but 1) they
may not be there 2) you can relate to whom originally submitted it.

SQL Server doesn't really track this information.  You would have to use
Profiler or a custom tracing mechanism to audit all of the queries.

There are some built-in reports in Management Studio that will show you top
10 queries by cpu, i/o etc., and you can also write your own against the new
DMVs (which provide much more real-time information than sp_who/sp_who2
etc).  See the following for some ideas:

http://sqlserver2005.databases.aspfaq.com/how-do-i-mimic-sp-who2.html
http://sqlserver2005.databases.aspfaq.com/better-sp-who2.html

And once you have SP2 you can create custom reports in Management Studio;
see

http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/19/448.aspx




Show quoteHide quote

Backup using the proxy account in SQL2005
BCP genric error
Problem on scripting stored procedures
Telling if SQL2005 is running
SMSS - script to new window uses sp_executesql?!