Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Where is sys.dm_tran_session_transactio ns in SQL2000?


Hi,

Can anyone tell me where I can get information [in SQL2000] about
transactionId started in particular session?

In MSSQL 2005 there is nice system view sys.dm_tran_session_transactions,
which I can use.
I can get this information from locks table,  if session put some locks, but
this method is not nice nor clean.
Please advise.

Thank you very much in advance.

Michal

The SQL 2005 dynamic management views are much more robust than the SQL 2000
system tables and procs.  I don't know the underlying requirement that
drives the need for the transaction id but perhaps you can use
sp_getbindtoken instead.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mku" <michal@@kupczyki..eclipse..co..uk> wrote in message

news:uSIou5BqHHA.4152@TK2MSFTNGP04.phx.gbl...

"Dan Guzman"

>  I don't know the underlying requirement that drives the need for the
> transaction id but perhaps you can use sp_getbindtoken instead.

Thank you for a quick answer.
each process can get own bindToken -true, but I do not know the way of
getting other processe's bindToken

I need a function like

int GetSPIDsCurrentlyOpenTransactionId(int SPID)

in SQL2005 sys.dm_tran_session_transactions gives required info.

The need for TransactionId comes from the idea of identifying code causing
excessive database locks by matching application activity in each SQL
transaction.

Regards
Michal

-----------------------------------------------Reply-----------------------------------------------

Sorry, but I can't think of a method to get a transaction id from another
session in SQL 2000 other than the method you already mentioned.  Maybe it's
time to upgrade ;-)

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mku" <michal@@kupczyki..eclipse..co..uk> wrote in message

news:%23SEto8DqHHA.3736@TK2MSFTNGP03.phx.gbl...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc