[SQL 2005] UPDATED: PRB: 'Script table as' reports an error for linked servers created using...

Full Title: PRB: 'Script table as' reports an error for linked servers created using MSDASQL provider in SQL Server 2005 and SQL Server 2008

Symptom

Consider the following scenario:

  1. You create a linked server from SQL Server 2005 or SQL Server 2008 to an ODBC data source using Microsoft OLEDB provider for ODBC drivers (MSDASQL) in SQL Server Management Studio.
  2. You try to use the 'Script Table as' option on one of the tables on the linked server in the SQL Server Management studio.

In this scenario, you will receive the folowing error message in the second step:
[LinkedServer].[ DatabaseName].[dbo].[TableName] contains no columns that can be selected or the current user does not have permissions on that object.

http://support.microsoft.com/kb/971261

Read the complete post at http://wmug.co.uk/blogs/cliffs_blog/archive/2009/05/23/sql-2005-updated-prb-script-table-as-reports-an-error-for-linked-servers-created-using.aspx

Published Saturday, May 23, 2009 9:08 AM by Cliff Hobbs - FAQShop.com and Microsoft MVP ConfigMgr/ SMS