Hi,
I've created a SQL Server Express Database that is used by an ASP.NET 2.0 application (developed using VWD Express).
I would like to be able to:
- Make changes to stored procedures, views and table structures while developing/testing ASP.NET application - which, ideally, needs a SQL Server Manager Studio Express connection and Upload my application and data to a database on a network - which, ideally, needs a direct Database.mdf connection.
I know that I need to change my connection string - and am able to achieve that with ease - but I'm not sure what the best way of switching between the two ways of attaching on the database side. I keep getting logon type problems etc.
Thanks very much.
Regards
Gary
Hi,that should be normally straight forward using on of the user instances string for "attaching" the database to a instance temporarly (www.connectionstrings.com) Which error do you get while attaching ?
HTH, JEns Suessmeyer.
http://www.sqlserver2005.de
