about transaction?

How can i say how many and what transactions on the current db?
Also the time-stamp for each of transaction?
many thanks

See "dbcc opentran" in BOL.

Example:

dbcc opentran (0) with tableresults

AMB

|||

In SS2005, you can also use a DMV

Code Snippet

SELECT sys.dm_tran_active_transactions