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?

  • May 27, 2009 at 6:29 am

    #1000517

    GRE (5/27/2009)

    Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?

    Yes, both the attach and detach stored procedures are deprecated, here is the page for sp_detach_db from Books Online (see the Important box just after the syntax section):

    http://msdn.microsoft.com/en-us/library/ms188031.aspx