Close the SQL Server database all usage connections

To terminate with a stored procedure:
Create a terminating database for all successive stored procedures under Query Analyzer, by calling the stored procedure to close all connection operations that use the database.
--Create a stored procedure that terminates all processes under the database, with the parameter database name
Use master
Go
Create proc Killspbydbname (@dbname varchar (20))
As
Begin
declare @sql nvarchar ($), @temp varchar (1000)
DECLARE @spid int
Set @sql = ' Declare getspid cursor for
Select spid from sysprocesses where dbid=db_id ("' [email protected]+ ') '
EXEC (@sql)
Open Getspid
FETCH NEXT from Getspid to @spid
While @ @fetch_status <>-1
Begin
Set @temp = ' Kill ' +rtrim (@spid)
EXEC (@temp)
FETCH NEXT from Getspid to @spid
End
Close Getspid
Deallocate getspid
End

--use, for example, to close all connection operations under the database
Use master
Exec killspbydbname ' database name '

Close the SQL Server database all usage connections