November 21, 2004 at 10:56 pm
Hi,
I want to write a query involving in two diffrent servers in SQL QA. how can i achieve this ?
Jeswanth
--------------------------------
November 21, 2004 at 11:40 pm
November 22, 2004 at 12:19 am
Thanks "Growl" learning the stuff.
--------------------------------
November 23, 2004 at 11:20 am
Depending on your needs, an OPENROWSET might be used (e.g., in a join, to load a temp table, etc.)
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 23, 2004 at 11:27 am
However it's done, be carefull to limit the records when possible. In the OPENROWSET, be sure to use a WHERE when possible to limit the records returned. With linked servers, simple joins might pull entire table over. If so, consider using the REMOTE keyword in the join - see BOL. Otherwise, perhaps a derived table, using a WHERE, might work to limit the record counts.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
November 26, 2004 at 7:58 am
Hi growl and stone
Thanks for the replies it was really informative. each time i post a question i learned a lot . in fact i done the job through a linked server. and the work was in development environment to compare two tables in diffrent servers
so no resources issue .
thanks a lot
jeswanth
--------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply