May
9

SQL: drop current connections

You can view the current connections by executing the system proc
sp_who2 , if you wish to kill the connection type: kill and the pid number

or use

ALTER DATABASE ‘DATABASE_NAME’ SET SINGLE_USER WITH ROLLBACK_IMMEDIATE.

Posted in SQL
Comments Off Posted by admin

Comments are closed.