Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
curiousbynature2111
Starting Member
4 Posts |
Posted - 2013-04-24 : 18:23:06
|
Hi, If i execute a query using the query analyser in SQL management studio (SQL 2008 R2) is the query and or results recorded anywhere on the server?If so how can I see that?Many thanks for any responses. |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-04-24 : 18:31:03
|
The query will be stored in the procedure cache, but not the results. You can get the query text via sys.dm_exec_sql_text and passing in the sql_handle. You can get the SQL_HANDLE from sys.dm_exec_query_stats, or sys.dm_exec_requests (maybe other places)-Chad |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-24 : 18:34:40
|
Something like this will give you some details, but these are really management views; not stored into a table. So if you restart the server for example, you won't be able to get anything that happened before the restart.SELECT * FROM sys.dm_exec_query_stats CROSS APPLY sys.dm_exec_sql_text(sql_handle) YOu can filter and sort the results to fit your needs. |
|
|
curiousbynature2111
Starting Member
4 Posts |
Posted - 2013-04-24 : 18:35:15
|
Many thanks Chad. Is the query stored permanently in the procedure cache?The reason I'm asking is I found some very suspicious behavior and would like to bring it to light but because of the nature of my management I wouldn't like it known that I ran a query to confirm my suspicions. I'd end up the bad guy if you know what I mean. |
|
|
curiousbynature2111
Starting Member
4 Posts |
Posted - 2013-04-24 : 18:37:34
|
Many thanks for that reply too James K |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-04-24 : 18:45:22
|
No, it will either be aged out of the procedure cache, or get flushed when SQL gets restarted (or the cache is flushed manually)-Chad |
|
|
curiousbynature2111
Starting Member
4 Posts |
Posted - 2013-04-24 : 18:52:55
|
Many thanks Chad. Thanks for taking the time to reply. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-04-24 : 18:54:06
|
You are welcome!-Chad |
|
|
|
|
|