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 |
|
nati_nieves
Starting Member
4 Posts |
 Posted - 2002-05-06 : 10:08:00
|
| HiI've created a linked server from one server (database in Sql Server) to other server (in Sql Server too) and the next instruction go OK:select *from linkServ1.db1.dbo.table1Then I execute: sp_tables_ex 'linkServ1', table1' and it gives me all information about the table TABLE1 of the linkServ1 linked server.The next action was to create other linked server from one server (database in Sql Server) to other server (in Ingres). I executed :select *from openquery (linkServ2, 'select * from centro')and it was OK. But when I did:select *from linkServ2.cat1.ing.centrowhere cat1 is the catalog, ing is the owner and centro is the name of the table. This instruction wasn't OK. Then I did: sp_tables_ex 'linkServ1', centro' and in the TABLE_CAT field is put a NULL. Then, how can I do the instruction 'linkedservername.catalog.schema.tablename' if catalog is null ?, because I put:select *from linkServ2..ing.centro and nothing.Can you hel me, please?????Tahnk you very much.Edited by - merkin on 05/06/2002 19:11:05 |
|
|
|
|
|
linkedservername.catalog.schema.tablename