Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Moving Database Files Detach/Attach or ALTER DATABASE? RE: Moving Database Files Detach/Attach or ALTER DATABASE?
Hardy21
SSCrazy Eights
Points: 9708
More actions
September 27, 2010 at 5:38 am
#1227620
Thanks for nice article.
But, BOL is also using "sp_detach_db" command to describe attach database command as below:
USE master;
GO
sp_detach_db Archive;
CREATE DATABASE Archive
ON (FILENAME = 'D:\SalesData\archdat1.mdf')
FOR ATTACH ;
Thanks