Connection Strings:How can I point to multiple Databases using sqlserver2008
I am new to asp and my query is ,If i had 2 or more SqlServer databases for eg:userDB,CompanyDB1,CompanyDB2 etc,then depending upon the users logged in from userDB table I want to point each users to unique databases,i.e,user1 gets data from company1 database,user2 getas data from company database2 and so on.
Then how should i write connection strings
|