I recently learnt that when a database is part of Availability Group or in Database mirroring, it can’t be set in SINGLE_USER mode.
Can't Set SINGLE_USER Mode in Availability…
I recently learnt that when a database is part of Availability Group or in Database mirroring, it can’t be set in SINGLE_USER mode.