sql server:alter database name的問題

--step?1?:?修改數據庫名稱  USE?master  GO  ALTER?DATABASE?GeovinDuCms?SET?SINGLE_USER?WITH?ROLLBACK?IMMEDIATE  GO  EXEC?master..sp_renamedb?'GeovinDuCms','DuCms'  GO  ALTER?DATABASE?DB_SHANGHAI?SET?MULTI_USER?  GO    --step?2?:?查看修改名稱后的數據庫邏輯名及物理文件名  USE?master  GO  SELECT?name?AS?[Logical?Name],?physical_name?AS?[DB?File?Path],type_desc?AS?[File?Type],  state_desc?AS?[State]?FROM?sys.master_files  WHERE?database_id?=?DB_ID(N'DuCms')  GO    --step?3?:?修改數據庫邏輯文件名稱  USE?master  GO  ALTER?DATABASE?DuCms?SET?SINGLE_USER?WITH?ROLLBACK?IMMEDIATE  GO  ALTER?DATABASE?DuCms?MODIFY?FILE?(NAME=N'GeovinDuCms',?NEWNAME=N'DuCms')  GO  ALTER?DATABASE?DuCms?MODIFY?FILE?(NAME=N'GeovinDuCms_log',?NEWNAME=N'DuCms_log')  GO  ALTER?DATABASE?DuCms?SET?MULTI_USER?  GO      --step?4?:?修改數據庫物理文件名稱之前先打開xp_cmdshell支持  USE?master  GO  sp_configure?'show?advanced?options',1  GO  RECONFIGURE?WITH?OVERRIDE  GO  sp_configure?'xp_cmdshell',?1  GO  RECONFIGURE?WITH?OVERRIDE  GO    --step?5?:?重命名數據庫物理文件名稱    USE?[master]  GO  ALTER?DATABASE?DuCMS?SET?OFFLINE?WITH?ROLLBACK?IMMEDIATE  GO  EXEC?xp_cmdshell?'RENAME?"E:2005databaseGeovinDuCms.mdf",?"DuCms.mdf"'  GO  EXEC?xp_cmdshell?'RENAME?"E:2005databaseGeovinDuCms_log.ldf",?"DuCms_log.ldf"'  GO    --step?6?:?將數據庫邏輯名稱指向新的物理文件，并將數據庫online  USE?[master]  GO  ALTER?DATABASE?DuCMS?MODIFY?FILE?(NAME?=DuCms,?FILENAME?=?'E:2005databaseDuCms.mdf')  GO  ALTER?DATABASE?DuCMS?MODIFY?FILE?(NAME?=DuCms_log,?FILENAME?=?'E:2005databaseDuCms_log.ldf')  GO  ALTER?DATABASE?DuCMS?SET?ONLINE    --step?7?:?查看全部修改完成后的數據庫情況  USE?master  GO  SELECT?name?AS?[Logical?Name],?physical_name?AS?[DB?File?Path],type_desc?AS?[File?Type],  state_desc?AS?[State]?FROM?sys.master_files  WHERE?database_id?=?DB_ID(N'DuCMS')  GO    --step?8?:?關閉xp_cmdshell支持  USE?master  GO  sp_configure?'xp_cmdshell',?0  GO  RECONFIGURE?WITH?OVERRIDE  GO  sp_configure?'show?advanced?options',0  GO  RECONFIGURE?WITH?OVERRIDE  GO    USE?DuCMS  GO