Change SQL Database Single and Multiuser Mode

Change SQL Database Single and Multiuser Mode

this i unfortunately had to learn on the fly, not sure how it happened, but let’s just say that it did.

i noticed a bunch of my SQL Server Databases had the (Single User Mode) around them, my first thought was “no big” as long as its running, I’m the only one using them.  NOT

in the actual database, make sure that under options, at the very bottom, it’s set for multiple, or more than likely you will have database issues.