SQL single user mode (DAC: Dedicated Administrator Connection)

If you are stuck with SQL Single server connection mode then you can use DAC (Dedicated Administrator Connection) to the rescue:

1. Go to New Query.
2. Type the following into the Server Name dialog box: ADMIN:ServerName\InstanceName (eg: ADMIN:MSSQL\SQLDEV).
3. Now you can run any scripts needed against your database in Single User Mode.