How long has transaction been open?

Does anyone know how to determine how long an open
transaction hase been open? None of the columns in
sysprocesses seem to provide that.
ThanksCheck out DBCC OPENTRAN in the BOL.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:2a1601c3fcad$eaf28550$a501280a@.phx.gbl...
Does anyone know how to determine how long an open
transaction hase been open? None of the columns in
sysprocesses seem to provide that.
Thanks|||> Does anyone know how to determine how long an open
> transaction hase been open? None of the columns in
> sysprocesses seem to provide that.
See DBCC OPENTRAN, it displays information about the oldest active
transaction and the oldest distributed and nondistributed replicated
transactions, if any, within the specified database.
http://msdn.microsoft.com/library/d...
fhq.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.