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.
| Author |
Topic |
|
WATERKID
Starting Member
6 Posts |
 Posted - 2007-03-12 : 19:54:17
|
Not sure this is simple or possible but here it is anyway...Can I make a view from Different Servers ?I'm trying to create a view that displays a table from ServerA and would like a column to be included from a table from ServerB that has a matching ID. I'll be using this combined view in a VBapp. Sounds simple but I keep running into problems using the SQL Server Enterprise Manager.Hopefully its just a syntax issue ?Thanks to anyone familiar with this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-12 : 20:00:45
|
| You can reference objects on a different server if you use a linked server. You can then use the 4 part naming convention for the object:LinkedServerName.DatabaseName.ObjectOwner.ObjectNameTara Kizer |
 |
|
|
WATERKID
Starting Member
6 Posts |
Posted - 2007-03-13 : 12:40:26
|
| Thanks for the hint.I'll be trying this out today.I have both servers connected in the Enterprise Manager, I've never linked them before so I'll do a bit of reading on that.At least it sounds possible, Thanks again. |
|
|
|
|
|
|
Combine views from Different Servers