User per database


dear all,

a part enterprize manager how can query number of user connected prticular database.

regards

sufian

you can use sp_who, sp_who2 ,

select user_name(uid),*from sys.sysprocesses where dbid=db_id('somedatabase')

 

madhu

 



SQL Server  >  SQL Server Database Engine



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more

Problems installing SQL Server 2014 - There was a failure to calculate the applicability of setting LICENSEPATH.

hi, after googling frantically solution problem decided try here. i upgraded windows 7 windows 10 when came available , had previous versions of sql server installed before uninstalled them before upgrading windows 10. there alot of traces of old installations , after spending hours removing them using msiinv.exe , cleaning out registry, there shouldn't left. still same error when trying install sql server 2014:  there failure calculate applicability of setting licensepath. this applies both standard , express version. standard version run iso , express version .exe file. edit: noticed have same culture id problem op in: https://social.msdn.microsoft.com/forums/sqlserver/en-us/a8a52f80-764d-4a01-b60a-1c4c363d1150/error-while-trying-to-upgrade-sql-2008-sp2-to-sql-2012-there-was-a-failure-to-calculate-the i live in finland apart timezone , keyboard settings set english. can't issue since it's worked fine before previous versions of windows. below summary.txt...
Read more