Might I recommend a bit more on this.
Joining via linked-servers to the production system is not a good idea
[in most environments], be carefull.
Perhaps...
On production, select the KEYS only from the tables in question to
another [temporary in nature - but real table] ProdKeys.
Then, from the other server, join on the ProdKeys table, and you will
not get a screaming DBA in your office - wondering why you are causing
timeouts in all the applications.
Why KEYS only... That's all you need to do the left-join to see what is
missing.
Add more columns later, when you need them.
There are tons of variations on this, but the KEY is, don't' join to
prod tables via linked-servers.
Dano
-----Original Message-----
From: Swasey Steve D CTR 554 ELSG/FNF
[mailto:mssqldba-ezmlmshield-x70449308.[Email address protected]
Sent: Monday, February 26, 2007 3:50 PM
To: LazyDBA Discussion
Subject: RE: Inner joining different servers
Importance: Low
Marty:
If I understand you right, you want to create a query that uses tables
on different servers?
That shouldn't be any problem. Just create linked servers and you can
then create a query on one server that "queries" any of its linked
servers.
Steve
-----Original Message-----
From: Marty Galvan
[mailto:mssqldba-ezmlmshield-x20370228.[Email address protected]
Sent: Monday, February 26, 2007 3:46 PM
To: LazyDBA Discussion
Subject: Inner joining different servers
Is it possible to inner join servers on a query? I want to check one
server that is used for web orders to make sure they are getting
imported into our business system. I want to write a query and do a
check to see if they got moved over. Is this possible?
Thanks,
Marty Galvan
DB/EDI Admin
Making Memories
[Email address protected] <mailto:[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page