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

• MsCode_Pro

  Say Hey Kid

  Points: 690

  More actions

  June 9, 2008 at 6:49 am

  #183311

  Hello Professionals, How can i attach and detach my mdf file to an instanse of sql 2005 programatically or by T-SQL[:)]

  YoU CaN't LoSe WhAt YoU NeVeR HaD;)

• VastSQL

  SSC-Dedicated

  Points: 36121

  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

  😀