How to rename database using T-SQL in SQL Server 2005/2000/2008?
Very simple J Microsoft have provided one system SP which can be used here.
Sp_RENAMEDB
This SP needs two parameters 1st Database name which needs to be change
And 2nd New name.
SP_RENAMEDB ‘MyDB’ , ‘YourDB’
That’s it.
No comments:
Post a Comment