Error opening table in linked server with Objects Explorer:

Error opening table in linked server with Objects Explorer:


contains nocolumns that can be selected or the current user does not havepermissions on that object. Reply The message "contains no columns that can be selectedor the current user does not have permissions on that object" indicatesthat the query to obtain the data you have obtained the tables using the SQL Server ManagementStudio Object Explorer Wizard. Unfortunately, this wizard does not supportoperation with third-party ODBC sources. We cannot influence this behavior. This means that, toobtain the data from table, you can use the following query without using thewizard: Select * From [LinkedServerName]...[table]