Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Most geographically distant SQL statement ever...

Author  Topic 

jackstow
Posting Yak Master

160 Posts

Posted - 2002-03-20 : 15:56:21
Something that setbasedisthetruepath said today set me a-thinking

quote:
Generally speaking, SQL Server allows you to reference objects using a four-part naming convention:
[server].[database].[owner].object



... so you can run an SQL statement on several servers/databases at the same time. Anyone know of the largest/most geographically distant example of such a statement? Maybe here at SQLTeam we have the resources to create the biggest, most distant, most utterly useless multiple table join of all time. Guiness book of records here we come..!

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-03-20 : 16:23:34
Well, one end will have to be me. Adelaide (South Australia) has to be about as far from anywhere as you can get. I'm actually talking to you by rubbing two sticks together and pedalling hard...



--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page
   

- Advertisement -