ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE MyDB modify file(Name=N'MyDB',NewName=N'TaskManager') go alter database MyDB modify file(Name=N'MyDB_log',newName=N'TaskManager_log') go exec sp_detach_db @dbname=N'MyDB' go sp_configure 'xp_cmdshell',1 go reconfigure with override go exec xp_cmdshell 'RENAME "E:\MyDB.mdf","TaskManager.mdf"' go exec xp_cmdshell 'RENAME "E:\MyDB_log.ldf","TaskManager_log.ldf"' go create database TaskManager ON (Filename=N'E:\TaskManager.mdf'), (Filename=N'E:\TaskManager_log.ldf') for attach go alter database TaskManager set multi_user go
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)