SQL Server Express DB Access

[Bruce Fox]

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,

[mendhak]

That MDF is local to the application, not the users of the application.

Best practice is to use an actual SQL Server database as MDFs are meant for SQL Express (SQL Express handles all requests "to" the MDF). And hosts don't usually support this as they will usually have SQL Server proper.