>
>So, I'll post another thread in SQL Server forum in a sec., but just in case, how can I use two connection strings to switch between development/local?
>
>The connection string is in web.config
>


I just have them all in config.web and comment out the ones I'm not using like this...

		<!-- TEST - SQL2005 
			<add key="SqlConnectionString" value="MyConnectionStringTEST"/> 
		-->
		
		<!-- DEBUG - SQL2005 
			<add key="SqlConnectionString" value="MyConnectionStringDEBUG"/> 
               --> 
	     
		<!-- DEV - SQL2005 
			<add key="SqlConnectionString" value="MyConnectionStringDEV"/> 
                --> 
		
		<!-- Local DB	SQL 2K 
			<add key="SqlConnectionString" value="MyConnectionStringLOCAL2K"/> 
		-->
		
		<!-- Local DB	SQL 2005 -->
			<add key="SqlConnectionString" value="MyConnectionStringTESTLOCAL2005"/> 

Bruce