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 |
|
kjk_kjp
Starting Member
18 Posts |
 Posted - 2009-01-09 : 16:48:12
|
| I have SQL SERVER 2008 running on 2 different machines.I'm trying to create a view on server A that needs to query against a table on server B.Server A IP: 172.16.0.70Database Name: ODSliveServer B IP: 192.168.1.10Database Name: NX3liveodsTable Name: dbo.Student_TermWhat do I need to do to reference Server B in my View on Server A |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 18:00:09
|
| Create Linked Server and use Four part naming convention likeservername.dbname.schema.tablename. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Reference table from a different SQL server