Monday, 25 June 2012

Determine No of users connected to sqlserver database


select spid, status, loginame, hostname, blocked, db_name(dbid),
cmd from master..sysprocesses where db_name(dbid) = 'IMarque_db'
and spid>50

No comments:

Post a Comment