|
-
Mar 7th, 2001, 12:33 PM
#1
Thread Starter
Need-a-life Member
Is there any way to link a table of another database in SQL Server? (as in MS Access). If so, how?
Emiliano F. Martín
 If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the  image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
-
Mar 10th, 2001, 12:57 AM
#2
New Member
SQL link
Haven't work with SQLsvr long time, but try this one:
SELECT a.field1, b.field1
FROM firstdbname.tablename a, seconddb.tablename b
WHERE a.linkfield=b.linkfield
In INFORMIX you need the two DB to be in same states (loged ...)
Good luck
-
Mar 10th, 2001, 01:17 AM
#3
Hyperactive Member
Expanding vbzen's comment, create a view in the first db for the table in the second and, of course, set the appropriate r&p. Just a thought.
-
Mar 11th, 2001, 03:50 PM
#4
Thread Starter
Need-a-life Member
Sincerely, I didn't understand either of them. However a Friend of mine told me to copy the table in the other database and set a DTS to keep it updated. Is this better solution than yours? If not, please explain me better.
Emiliano F. Martín
If a post has helped you then please Rate it! (and give the user points he/she deserves by clicking on the image).
Encourage the person who helped you to keep doing it, and give him the points he deserves.
MP3 Organizer: Freeware to logically organize all your MP3s.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote