Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 7,2000 » Administration » current sessions in database
Add to briefcase

current sessions in database Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ananda.murugesan
Posted Thursday, December 25, 2008 5:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:54 PM
Points: 823, Visits: 2,404
hi,

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

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:39 PM
Points: 11,638, Visits: 27,713
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
ps.
Posted Thursday, December 25, 2008 10:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.