July 8, 2010 at 8:38 am
how can we find the query which is run y'day, as we lost data we want to anlayse what the sql activites at that point of time .
July 8, 2010 at 8:45 am
Not without actively tracing the machine at that point in time.
July 8, 2010 at 9:28 am
You're basically completely out of luck.
You might be able to query the cache to see which procedures might have a last run time near the time of the data loss (sys.dm_exec_query_stats), but that's really not going to offer you much, at all.
Unless you had a trace running to capture queries, there's nothing built in.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply