anthony.green (1/9/2013)
The above will do exactly the same as what you are trying to do, just it is the new way of doing it.
so it means
ALTER DATABASE myDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
command will kill all spids as well as set database into SINGLE_USER ?