SQL Server database cannot rename error 5030

The use of MSSQL when learning ASP. ' Often this error, the database can not duplicate name 5030 error, in fact, the simple reason is that there is an application is occupying this connection, using such a line of command can query out the occupied connection

 Use Master    Select  from  where dbid=db_id('odatabasename'

The result of the execution is a number of numbers such as the total, the use master Kill 23 90 can be, in the case of a foreign user access to the database execution

EXEC sp_dboption ' olddbname ', ' Single User ', ' TRUE '
EXEC sp_dboption ' newdbname ', ' Single User ', ' FALSE '

These two statements mean that the database is converted to single-user mode and non-single-user mode, which prevents other users from manipulating the database when renaming the database, causing deadlocks.

SQL Server database cannot rename error 5030