Check for the active connections in a particular database
Use master
go
select a.* from master..sysprocesses a,
master..sysdatabases b
where a.dbid=b.dbid
and b.name='<database_Name>'--you have to give your database name
Result:
No comments:
Post a Comment