Rename MSSQL Server Database

This article: provides three easy tsql commands to rename a sql server db. I've quoted it below; however, I strongly suspect that the scribble code will filter it out:

EXEC sp_dboption 'Training', 'Single User', 'TRUE'
EXEC sp_renamedb 'Training', 'Cybex-Plum-Test'
EXEC sp_dboption 'Cybex-Plum-Test', 'Single User', 'FALSE'
Run these in query analyzer, osql or whatever.
Related Scribbles:
  • MSSQL Table Analysis Queries
  • SQL Server

  • ID: 770
    Date Updated:
    2006-05-18 09:43:07
    Date Created:
    2006-05-10 14:44:09


     >> Leonard Chan's Homepage  >> Scribble Web  >> Rename MSSQL Server Database is hosted by Perceptus Solutions Inc.