Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A report sitting on one server accessing a view on another

Status
Not open for further replies.

KidFix

Programmer
Feb 7, 2002
60
US
ello all

is it possible for a report to access a view on a different server? if so, how is it done?

Thanks
 
If you mean can a report on one server (or PC) be generated against data sitting on another server (or PC) then the answer is Yes.
As long as there is access from the first server to the second - with the appropriate information required to access the database tables, namely location, table names, user name and password if required.
I hope that this helps.
Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top