TravisDBA (2/15/2011)
This works easier for me. The only reason to kill all the spids usually anyway is to put the database into another mode besides multi_user. 😀
I use it when I need to restore a database and there are open connections to the database I want to restore. (This is usually during development when I need to restore a copy of a production database onto a staging or development server.)