SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS Reporting Using Linked Servers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

newbie600
Starting Member

USA
5 Posts

Posted - 04/16/2014 :  15:22:43  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000