Monday, July 12, 2021

Change Data base name in SQL through query.



USE master

GO


ALTER DATABASE AXDB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO


EXEC master..sp_renamedb 'AXDB','AXDB_Old'

GO


ALTER DATABASE AXDB_Old

SET MULTI_USER

GO


Keep daxing!!

No comments:

Post a Comment