mm 2.4 mssql 2005
I have a web service that must insert data into the same table in multiple databases. All databases are on the same sql server. I know that I can create multiple connection strings and use the databasekey to select the proper db but new databases are added often and this makes for a maintenence a nightmere. I tried execnonquery("use mydatabase") then and saved a new row but it inserted into the db specified in the connection string. Any suggestions on how to best do this ?
Thanks,
Bill