Obtain the current SQL server connection and how to disconnect it

It is very easy to get connection information

Sp_who

 

Disconnected:

Kill PID

PID is the ID in the connection information

 

 

The following is a process of disconnecting all users in the specified database (in the master database)
Use master
Go

If exists (select * From DBO. sysobjects where id = object_id (n' [DBO]. [sp_killspid] ') and objectproperty (ID, n' isprocedure') = 1)
Drop procedure [DBO]. [sp_killspid]
Go

Create proc sp_killspid
@ Dbname sysname -- Name of the database to be disconnected
As
Declare @ s nvarchar (1000)
Declare TB cursor local
For
Select n 'Kill '+ Cast (spid as varchar)
From master .. sysprocesses
Where dbid = db_id (@ dbname)

Open TB
Fetch next from TB into @ s
While @ fetch_status = 0
Begin
Exec (@ s)
Fetch next from TB into @ s
End
Close TB
Deallocate TB
Go

-- Call
Exec sp_killspid 'A'