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 |
|
visweswaran28
Starting Member
4 Posts |
 Posted - 2012-08-14 : 12:04:16
|
| HI,I want to retrieve list of executed query for a specific date in sql server.Thanks in Advance |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-14 : 12:33:59
|
| Were you running a trace on that specific date?-Chad |
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-14 : 12:34:47
|
this may slightly serve your need:SELECT *FROM sys.dm_exec_query_stats --------------------------Joins are what RDBMS's do for a living |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-14 : 12:38:28
|
| Only if the query is still in cache, and only if it hasn't executed again since the date he is looking for.-Chad |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-08-14 : 12:43:32
|
| Better install a very nice (and FREE) tool for SQL Server Management Studio from http://www.ssmstoolspack.com/--------------------------http://connectsql.blogspot.com/ |
|
|
|
|
|
|
Get Executed Query for Specific Date