>>try select * from NJDATA.catalogname..EEMAST
>>
>>The trick is to define a catalogname when you define the linked server
>>
>>Good Luck!
>>Mike
>
>Did you get this to work? I tried it, just put a catalog name in the Create Linked server dialog... Then I tried my query:
>
>select * from njdata.catbob..eemast
>
>And I get the error:
>
>OLE DB provider 'MSDASQL' does not contain table "'catbob'\'eemast'".
>
>BOb

Yes, I got it to work. Can you see the EEMAST table when you browse the tables under you linked server? Did you read the article I pointed out under Books Online?

Mike