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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-23 : 10:34:58
|
| Christa writes "Is it possible to link SQL tables the way you can link them in Access? Ie in one database you have the real table, in another database you have a copy with the same real-time data." |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-23 : 10:40:18
|
| Hmm ... depends what you are trying to achieve here. You can join between databases, assuming that they have the same code page. That assumes they are on the same SQL instance. For different instances, you could go the linked server route, for example.It really depends on what you are trying to achieve... For real-time data, I would try and avoid duplicating the data.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Link SQL tables