June 11, 2007 at 7:02 am
Hi All,
Is there any way in sql server either 2000 or 2005 to find out what are the times that last n transaction have been commited to the database/server. It would be great if someone tells if they or discovers and let us know. I have searched enough but in vain.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 11, 2007 at 11:36 am
It might not be exactly what you're looking for, but have you looked into, what was in SQL 2000, the black box? Lookup sp_trace_create in BOL.
"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
June 12, 2007 at 5:14 am
I tried using the sp but could not find what i exactly wanted. i want to get the time for last few transactions might be before an hour or so.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply