Nice article on how to save you self with single user mode.

As has already been menationed know to use the -f switch is a question every DBA should ready for when in an interview.

This used to be something I would help developers do often before we started using a single "real" SQL server for development databses.