Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

current sessions in database Expand / Collapse
Author
Message
Posted Thursday, December 25, 2008 5:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:19 AM
Points: 1,044, Visits: 2,926
hi,

How do find current sessions in database access through sql server 2000? not in sql profiler.

thanks.



Post #625651
Posted Thursday, December 25, 2008 8:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 12,877, Visits: 31,791
do you mean something other than using sp_who or sp_who2?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #625658
Posted Thursday, December 25, 2008 10:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, July 6, 2014 3:07 PM
Points: 2,242, Visits: 3,643
sp_who2 works just fine for finding sessions. u can also query sysprocesses table.





Pradeep Singh
Post #625679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse