Identifying number of account logins on Sybase

Steve Neal Development Leave a Comment

If you quickly need to see how many logins there are for each account in sybase, you can use this query:

select dbname=db_name(dbid),login=suser_name(suid), #connections=count(suid) 
from master..sysprocesses 
--where  suser_name(suid) like '%dblogin%'
group by dbid, suid 
order by count(suid)

Leave a Reply

Your email address will not be published. Required fields are marked *