SQL Prompt 10

SQL Prompt is not showing all linked servers

SQL Prompt may not list all linked servers in the suggestions box.

  • This problem may arise if the SQL Prompt user does not have the VIEW ANY DEFINITION permission, which allows the user to access the list of linked servers. Use GRANT VIEW ANY DEFINITION TO <user> to allow the user to view all metadata in the SQL Server instance. To check if the user has the correct permissions, run the following query:

    SELECT srvname, srvproduct, providername FROM master..sysservers

    If the query fails, the user does not have the correct permissions.

  • This problem may also arise if the linked server is not a Microsoft SQL Server. SQL Prompt cannot access OLE DB data sources other than SQL Server instances.



Didn't find what you were looking for?