Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newbie600
Starting Member
5 Posts |
 Posted - 2014-04-16 : 15:22:43
|
| I am looking for someone who can direct me in setting up linked servers and writing the necessary queries to use the linked servers. I have two databases, on different servers. I access both databases using ODBC connections. On DB1 I run a query which collects loans booked during a specific time window. On DB2 I run a query which collects the 'loan packages' which have been scanned into our Optical database. Ultimately, I need to compare the query from DB1 to the query from DB2 to determine which loans have NOT had the 'loan packages' scanned into the optical system.My understanding is that I must set up the linked server in Management Studio and I am looking for the detailed steps to accomplish the correct setup. Once the linked servers are correctly setup, I need to be able to create the appropriate query to use the linked server setup.I know this looks like I'm rambling on.....hope I've provided enough detail to at least begin a dialogue.....Thanks, in advance, for your assistance...Ray Bond |
|
|
|
|
|
SSRS Reporting Using Linked Servers