(restricted user) after restoreQuestion:
hey all, when i restored my db from production to a virtual pc, (restricted user) showed up in parens next to the db. can someone please explain this and how i need to resolve it?
Right-Click on your database, and select New Query
to set to Multi user
ALTER DATABASE databasename SET MULTI_USER To set back to Restricted ALTER DATABASE databasename SET RESTRICTED_USER