CREATE DATABASE sqldbpool
–Solution – I
EXEC Sp_renamedb ‘SQLDBPool’, ‘Jugal’
–Solution – II
ALTER DATABASE sqldbpool MODIFY name=jugal
CREATE DATABASE sqldbpool
–Solution – I
EXEC Sp_renamedb ‘SQLDBPool’, ‘Jugal’
–Solution – II
ALTER DATABASE sqldbpool MODIFY name=jugal
Thanks for providing us valuable information and increasing our knowledge
You welcome!!!
We have to rename physical file names also. The above Procedure wont change file names.