Changing SQL Server Database Name

Discussion in 'Databases' started by Helenmary Cody, Jul 24, 2016.

  1. When I created my database, the system needed to add "DB_104835" to the beginning of the database name. I would prefer that the name not include this prefix. SSMS gives me an option to Rename, but I wanted to check that it wouldn't cause any problems if I did so. I have a feeling that it is necessary to insure unique names, but if I can change it I would like to do so.

    Thanks!
     
  2. Sorry, it isn't possible to remove the database name prefix. As you suspected, it's there for management purposes on our end. A rename command in SSMS will fail.
     

Share This Page