May 10, 2007 at 6:59 am
Hello All
We have a master DB in which we have table with connection strings of another Agency DBs.
Is there some way I can connect to the agency DB and query to get data from this connected Agency DB.
Thanks
Ankit
May 10, 2007 at 11:01 am
I'm not entirely sure what you mean, but I think you you're looking for something along the lines the OPENROWSET command. Look it up in Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 11, 2007 at 8:52 am
use linked servers and then u can include the table in your query using the 4 part naming convention i.e. LinkedAgencySvr.AgencyDb.dbo.SomeTable
you do not need to store the connection strings in your tables, unless if you plan to use them in a client app in which case you can use a config file
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply