Post reply

Active Users

  • July 18, 2013 at 3:19 am

    #277615

    Hi,

    How do i find out the number of users having an active transaction at the moment by using T-SQL Statement

  • July 18, 2013 at 3:31 am

    #1633571

    There are multipe ways to get this information. Below are some examples:

    select * from master.sys.dm_exec_sessions

    select * from master..sysprocesses

    exec sp_who2

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply