creating a view over 2 different sql servers

[jockey]

Hi All

I am not sure if this can be done but I hope it can. Currently we are running 2 sql servers. What I want to ba able to do is refrence table off ! of the servers in a voew on the other server.

So firstly can this be done. If it can what does it involve and how do you do it. I have tried a few thing but to no avail.

If anyone can suggest an answer or an alternative would be gratefull.

Cheers

Jamie

 

[ttba]

jockey,

Set up a linked server. The easiest way is to set it up via Enterprise Manager. You can also find info in Books Online...

ttba