How to change RDS MSSQL Database Name








How to change RDS MSSQL Database name

First you need to connect to the RDS MSSQL server



1.After connecting to RDS MSSQL server,

2.Open New Query window as master.

3.Copy and paste the below Query.

4.        EXEC rdsadmin.dbo.rds_modify_db_name N’OLD Databse name’, N’New Database name’

GO

Click Here!

5. Change the OLD database name as your existing database name.

6. change the New Database name as name you want to give to the database.

For example:

                     EXEC rdsadmin.dbo.rds_modify_db_name N’Reports’, N’Reporting’

GO

That’s it.



Please click on follow and put the suggestions in the comment section. Thanks.

 

How to check MSSQL Number Of ActiveConnections 

  • Comments
  • 0

Sign up for Newsletter

Sign up to get our latest exclusive updates, deals, offers and promotions.