Originally posted by Black Lung
Anyone know if you can create a view over multiple SQL Servers??
May I ask how?
If you are using MS SQL 2000
The short answer: Yes you can
The longer answer:
You will need to add all the other servers (the ones the calls are not originating from) using the stored proc: sp_addlinkedserver
Then you can reference them using something like:
SELECT * from ServerName.DatabaseName..TableName
*note the 2 dots before tablename, you can put the table owner name in between those, but it is not usually necessary.
Play around with it for joins, if you run into "mysterious" problems of it not selecting correctly, I suggest looking into specifying the COLLATION used when making the join.
If this all confuses you, some google searches of terms listed above could help.