# of users

[jscorpion]

Does anyone know the command to find out the number of users that are currently logged onto the SQLserver? Any information would be of great help.

Thank You,

jscorpion

 

[sunila7]

hi,
i think u could use this queries...

this is for a server
select distinct sysl.name from master..sysprocesses sysp,master..syslogins sysl
where sysp.sid= sysl.sid

this is for a DB.
select distinct sysl.name from master..sysprocesses sysp,master..syslogins sysl, sysdatabases sysd
where sysp.sid= sysl.sid and sysd.dbid = sysp.dbid and sysd.dbid = 7

Sunil

 

[tlbroadbent]

Select UserCnt=count(*) from master..sysprocesses Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[jscorpion]

thanks for your reply

Do you know if this command would work in Centura SQLbase or do you know the command for the SQLbase?

 

[tlbroadbent]

I'm not familiar with SQLBase. Check the documentation for a method to count current connections. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.