Change SQL server database from single-user mode to multi-user mode

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 is automatically changed to the single user mode during the copy. 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 mastersysprocesses

WHERE dbid = DB_ID ('database name ');

EXEC (@ SQL );

GO

Alter database name SET MULTI_USER;