SQL: drop current connections
Published by exdone
Posted on May 09, 2009
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.
- An error has occurred, which probably means the feed is down. Try again later.