Today we had an interesting use case where a customer reported that one of the databases they just restored from a backup got stuck in “Single-User” mode in one of their environments.
To resolve it, I first tried running the following command:ALTER DATABASE MyDB SET MULTI_USER WITH ROLLBACK IMMEDIATE;
In response, I got deadlocked with the dreaded error 1205:
There were a few different attempts with no success until Eitan came up with the final script. Eitan’s analogy was to curling, though the first thing I thought of was Odysseus fighting off his wife’s suitors as he came back to claim his home.