Answer: By Writing below code,we can find active SQL connections:-
SELECT db_name(dbid) as DatabaseName,count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid,loginame;
Asked In: Many Interviews |
Alert Moderator