After SQL Server becomes a single user, it cannot be accessed. You can set it to multiple users.

Today, I want to copy a database under SQL server2005. The result is an error in the last step. If the replication fails, the database cannot be opened,

The "single user" is displayed after the name. It is estimated that it will be automatically changed to the single user mode during replication. You can restore the multi-user mode by executing the following statement.

The principle is to kill the process that occupies the database first, and then set the database to multi-user mode.

Use master;
Go
Declare @ SQL varchar (max );
Set @ SQL =''
Select @ SQL = @ SQL + '; kill' + rtrim (spid)
From master .. sysprocesses
Where dbid = db_id ('database name ');

Exec (@ SQL );

Go

Alter database name set multi_user;