rename database name in sql server management studio 2014

Question

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

Before renaming, set the database to single user mode MSDN

USE master;
GO
ALTER DATABASE ip_ent_site
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;

Then rename it

USE master
GO
ALTER DATABASE ip_ent_site
Modify Name = ip_ent_site1
GO

And then put it back to multi user mode

ALTER DATABASE ip_ent_site1
SET MULTI_USER;

The reason is because the database has to prevent any other connection/transaction to the db while you are renaming it.

A simple script to get a lock on the db:

ALTER DATABASE [ip_ent_site] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE [ip_ent_site] MODIFY NAME = [ip_ent_site_new]
GO

ALTER DATABASE [ip_ent_site_new] SET MULTI_USER;    
GO

To enable the ability to

right click and rename

the DB:

1. Close all query windows
2. Right click & rename DB