Sql-server – Table not shown up on Linked Server

sql-server-2000sql-server-express

I have a machine which have 2 SQLServer instances

  • WINXP-PRO\SQLSERVER2000 (SQL Server 2000)
  • WINXP-PRO\SQLEXPRESS (SQL Server 2005 Express Edition).

In \SQLEXPRESS, I have database wavinet2 and wavinet2_mapic. In \SQLSERVER2000, I create linked server to [IP_ADDRESS]\SQLEXPRESS, the linked server is created.

All tables have shown up except for database wavinet_mapic.

I provide the remote login using sa. I try to select and it cannot found the table.

Any hint what is causing this problem?

Best Answer

My suspicion is that the table in question uses a feature that is only available in SQL Server 2005 and above and so that is why you cannot see it in your 2000 instance. This is similar to what happens when you try to open a SQL 2005 or above instance from Enterprise Manager - except you get a more descriptive error. If you desperately need to see this table in SQL 2000 remove the offending feature (if at all possible) from the table (it might just be a data type), if you cannot remove the feature then have a think about whether it is possible to have the link the opposite way around?

I hope this helps you.

Related Question