Thursday, January 27, 2011

Script to Rename Database


CREATE DATABASE sqldbpool
--Solution - I
EXEC Sp_renamedb  'SQLDBPool',  'Jugal'

--Solution - II
ALTER DATABASE sqldbpool MODIFY name=jugal 
Posted by at
Labels: , , , ,

2 comments:

  1. riddhi MishraJanuary 27, 2011 at 3:39 AM

    Thanks for providing us valuable information and increasing our knowledge

    ReplyDelete
  2. Jugal ShahJanuary 27, 2011 at 3:45 AM

    You welcome!!!

    ReplyDelete

Subscribe to: Post Comments (Atom)