Does anyone know how to determine how long an open
transaction hase been open? None of the columns in
sysprocesses seem to provide that.
ThanksThis is a multi-part message in MIME format.
--=_NextPart_000_008E_01C3FC84.72B5DE30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Check 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
--=_NextPart_000_008E_01C3FC84.72B5DE30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out DBCC OPENTRAN in the =BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Mike" wrote in message news:2a1601c3fcad$ea=f28550$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
--=_NextPart_000_008E_01C3FC84.72B5DE30--|||> 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/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5fhq.asp
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you both.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment