Tuesday, 2 May 2017

Check for the active connections in a particular database

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

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables Change Data Capture (cdc) property is disabled as default.  here I will Query you how t...