ALTER DATABASE DBA SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

SP_RENAMEDB DBA,DBA1

ALTER DATABASE DBA1 SET MULTI_USER WITH ROLLBACK IMMEDIATE;

Hope this should work for you.

Thanks,

Vijay