Thursday 8 November 2012

Script to Rename Database

CREATE DATABASE TESTDB

–Solution - I

EXEC Sp_renamedb ‘TESTDB’, ‘NEWDB’

–Solution - II

ALTER DATABASE TESTDB
MODIFY name=NEWDB
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)