Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

2 Answers
2

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?

Could you post the error? Without the error, my first thought would be to check the permissions on the sa account for that table (ensuring the user has access to SELECT the table). Along the same lines, I would also check to see if the linked server has all appropriate permissions for that table too.

There are no Error message because the linked server is crated successfully. Except that I can't see tables from database wavinet_mapic. I login using the sa account (which means superuser in sql, CMIIW) but I'll take a look again with the permission
–
PermanaJan 24 '12 at 2:47