Today, I restored a database in SQL Server 2008 and found that the words "single user" are always displayed on it, and there are error messages. Other databases are normal. I analyzed that this database may have been assigned user permissions before. Let me teach you how to convert a single user into multiple users.
Type a SQL query analyzer, enter the following commands and execute it:
Copy the codeThe code is as follows:
ALTER DATABASE [Database name] SET MULTI_USER