rename database name in sql server management studio 2014

Question

I have a database called "ip_ent_site". And I wanna rename it to "ip_ent_site1" for example.

I have done right click and rename, it is keeping on failed. This is the error message:

Anyone can help?

question from:https://stackoverflow.com/questions/30660204/rename-database-name-in-sql-server-management-studio-2014

Answer 1

That is because there are open transactions. If those transactions can be killed, then this can easily be done with this SQL

ALTER DATABASE ip_ent_site
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
sp_rename 'ip_ent_site', 'new_db_name' ,'DATABASE';
GO
ALTER DATABASE new_db_name
SET MULTI_USER
GO