Can i dynamically asign a database name to an existing SQL Server /lib connection whose logins/server is the same?
Hi,
I have an existing SQL Server connection setup using the Data Gateway and pointing and authenticating to a singular database however the same server also has a number of other databases (different company name) but with identical table names.
I could create a new connection to each database but i was wondering if there is a way, perhaps via "WITH CONNECTION" where i can specify the database name utilizing the same connection details but pointing to a the different database names? If so what that syntax should look like and if not is there another way?
