(restricted user) after restore
Question: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?
Answer:
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