>When and why do you see the need for attaching/detaching databases?
>Regards,
>Viv
The accountant (= accountant(s) + employees) decides to work on my data today (customer 27, year 2008). If (say) 00027_2008.mdf is not attached, it has to be attached to the sql server instance so he can work on it.
If another employer wants to work on my data at the same time, the 00027_2008.mdf does not have to be attached since it already is. So he can simply connect to it.
When the last person is done with 00027_2008.mdf, it has to be detached from the sql server instance [ we are talking about thousands of databases ]
Gregory