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

Details of users connected to my database Expand / Collapse
Author
Message
Posted Wednesday, March 9, 2011 3:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 11, 2012 3:55 PM
Points: 86, Visits: 206
Is it possible for me to check the number of users ( other necessary details ) connected to my database .

We are just dbo owners of that database and have access only to the query analyser of that database .

sp_who2 / sp_who3 commands are not working for me

P.S.- Please provide query that will solve the purpose .
Post #1075418
Posted Wednesday, March 9, 2011 3:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
Can you try

select * from sysprocesses



Mohammed Moinudheen
Post #1075425
Posted Wednesday, March 9, 2011 5:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 11, 2012 3:55 PM
Points: 86, Visits: 206
Even that is not working for us .
Like sp_who2 - it is showing only our connection , where there are other connections also present .
Post #1075447
Posted Wednesday, March 9, 2011 11:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
You need VIEW SERVER STATE permission on the server to run commands like sp_who2 etc.



Mohammed Moinudheen
Post #1076024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse