attach and detach my mdf file to an instanse of sql 2005 programatically or by T-SQL

• VastSQL

  SSC-Dedicated

  Points: 36285

  More actions

  June 9, 2008 at 7:16 am

  #826075

  Use "sp_attach_db" for attaching and "sp_detach_db" for detaching the database files.

  Check these links

  http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx

  http://msdn.microsoft.com/en-us/library/aa933267(SQL.80).aspx

  😀