SQL Server database changed from Single-user mode to multiuser mode

Today want to copy a database under the SQL server2005, the result of the last step error, replication did not succeed instead of the database can not open,

A "single user" appears after the name, which is estimated to be automatically changed to Single-user mode when replicating, and you can restore multiuser mode by executing the following statement.

The principle is to kill the process that occupies the database, and then set the database to multiuser mode.

Use master;

Go

DECLARE @SQL VARCHAR (MAX);

SET @SQL = '

SELECT @SQL = @SQL + '; KILL ' +rtrim (SPID)

From mastersysprocesses

WHERE dbid=db_id (' database name ');

EXEC (@SQL);

Go

ALTER database name SET multi_user;