rename database in sqlserver if database is running processes

use master;

Go

alter database M2wServices_tr_sh set single_user with rollback immediate;

GO

alter database M2wServices_tr_sh modify name = M2wServices_tr ;

GO

alter database M2wServices_tr set multi_user;

Go