DBILITY

mssql connection 확인 본문

database/mssql

mssql connection 확인

DBILITY 2020. 2. 6. 18:05
반응형
SELECT 
     DB_NAME(dbid) AS DB_NAME
	,COUNT(dbid) AS NUMBER_OF_CONNECTIONS
	,loginame AS LOGIN_NAME
	,MIN(login_time) AS FIRST_LOGIN_TIME
	,MAX(login_time) AS LAST_LOGIN_TIME
FROM sys.sysprocesses
GROUP BY dbid 
,loginame
ORDER BY DB_NAME(dbid)
반응형

'database > mssql' 카테고리의 다른 글

mssql lock확인  (0) 2021.07.05
mssql server "clr enabled" 구성 옵션을 설정하십시오"  (0) 2020.06.17
sqlserver connect by  (0) 2019.04.25
테이블 전체 삭제(DROP)  (0) 2019.04.24
sqlserver bulk insert  (0) 2019.04.15
공유하기 링크
'database/mssql' Related Articles more
Comments