Software Bugs and Solutions
Home
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment