• You can put any of the user databases on the box into single user mode.

    Why would you be developing against a production database? If needed, create a database on the same box, or install another instance on the box. You should not be developing on the same database that is being used as a production database.

    Is this what you mean? I am not totally clear as to what you actually need.

    Andrew SQLDBA