Have Geek Brain

VS2008 and SQL Express 2008

How to make SQL Express 2008 the default for VS2008 instead of SQL Express 2005?

0


a source to share


3 answers


If you add MDF to your website folder, I think you are using the Custom Instances feature . It is hardly advisable, and would be corrupted :

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new designs and plan to change applications that currently use this feature.



Instead of using custom instances, use Server Explorer to connect to Sql Server Express and create a database there.

+1


a source


In Visual Studio, go to Tools -> Options -> Database Tools -> Data Connections. There is a field for the name of the SQL Server instance.



I assume this is what you mean by default. Depending on what type of project you are creating, you usually specify a database connection.

0


a source


Are you using Visual Studio 2008 SP1? I think it might be required to support SQL Server 2008.

Otherwise, please tell us why you think 2008 is not a default. Are you getting an exception or error? Is there something that doesn't work?

0


a source






More articles:


All Articles