728x90

목록2020/02/06 (1)

DBILITY

mssql connection 확인

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 2020. 2. 6. 18:05
Prev 1 Next
728x90