SQL Prompt may not show all linked servers as candidates.

Cause

This can happen if the server at the other end of the "link" is not a Microsoft SQL Server.

SQL Prompt is looking for linked servers that use the SQLNCLI (SQL Server Native Client) or SQLOLEDB (SQL Server OLE) drivers. There are some multi-purpose drivers that can connect to SQL Server, but not exclusively, such as MSDASQL. Linked servers using this driver will not be selected as candidates by SQL Prompt.

How to fix

Your account needs to have the VIEW SERVER DEFINITION user rights to be able to catalog the list of linked servers. The account used to connect by SQL Prompt must be able to successfully run the following query:

SELECT srvname, srvproduct, providername FROM master..sysservers

If you continue to experience problems, please contact Red Gate Support.