Hi Guys,

I currently have a local MDF (App_Data) and was wondering if keeping the DB local is the right thing to do (especially when more than one user needs to connect).

My understanding is (in this configuration) that the MDF gets attached each time the web app runs, and dettached each time at termination.

In this case, what happens if another user joins, do they share the same attached MDF? (I susspect they do )

All that said, is it better practice to relocate from local, and have the MDF permantly attach AND configure Users to the SQL Server.


Cheers 'n' beers,