How i can see how many user using database?¿

[Marcio Vidal]

Hello,

I want do some store procedure for see how many users using database in this exactly moment.
I want do this because i need to stop DB for execute backup or restore.

And how i can kill all conection for do this.

thanks. Sorry i am learning !

[Marcio Vidal]

I see existe sp_who and sp_who2 , how i can filter user de one db ?¿ example only msdb

Thanks

[iburyak]

Try this select statement to view connected users.

select spid, loginame,b.name db_name, hostname, program_name,a.status,
login_time, last_batch, lastwaittype
from master..sysprocesses a
join master..sysdatabases b on a.dbid = b.dbid


To kill all connections at once I would set server in single user mode and kill that last connection and login by myself.
The thing is as soon as you kill all connections they still can connect back.

[Marcio Vidal]

Well i used one store procedure for filters users, databases etc....

But now i dont know how i can see how many users ( only number ) is connected in one database and put one button in one windows aplication for kill all users.

thanks

[Marcio Vidal]

I already resolve problem for kill users. Now i just know how i can put in windows aplication some messsage ( Have x users conected in db )