LINKED SERVERS -- sql server mseq

Phili
2/8/2004 11:33:39 PM

Hi all,

I am having problems with refrencing a table on a seperate
server than the one that I am working on (if that makes any
sense) I have never had this problem before. It keeps
saying that it cannont find that database name in the
sysdatabase table, which I know it shouldn't do as this
only contains database for the server I am working on. I
apoligise for the confusion here but I am afriad this is
the best explanation I could come up with. I am doing all
this through the query ana. window.

Any help would be great.

Ray Higdon
2/9/2004 6:29:02 AM

Your subject line has linked servers in it, have you added the other server
as a linked server? If not you need to, look up sp_addlinkedserver in BOL,
you can then access the other table by
servername.databasename.ownername.tablename

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

sql server mseq : LINKED SERVERS