Scripting from two servers - possible?

[Joell]

Hi All,

I am trying to report off of two different servers and sofware applications of information. Is it feasible to write a view, sql script that will pull information (not linked) in a timely manner from two different servers and then dump into Crystal for reporting?

The subreport route using Crystal will not be sufficient and very slow and the information will not be displayed in the output in the necessary format.

Any thoughs suggestions how to tackle this one? Could you provide an outline that I could follow?

Thanks!
Jo

[iburyak]

Create a view on one server and use it in your report.
To access data on another server without linking use following you can join such structure with any table on current server :

SELECT *
FROM      OPENDATASOURCE(      
          'SQLOLEDB',      
          'Data Source=server_name_here;User ID=user_id_here;Password=pwd_here'      
          ).database_name.dbo.table_name

Good Luck

[Joell]

Thank you very much. I appreciate the help. Will see what I can do with the information you gave me. :)

Jo