How Can i Attach and Detach my MDf file Programatically or by T-SQL

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

To attach a database, check out Create Database in Books Online. There's a "for attach" argument you can use.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 2

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

Check these links