Allow SQL Prompt to work with no access to master.sys.sysservers table
SQL Prompt fails when the user does not have access to the sysservers table in master database. It is becoming increasingly common for DBA groups to revoke/deny this permission to developers. For our org it was the result of an independent audit/penetration test. There are other procedures etc the provide the same information without this specific access. I have provided examples and troubleshooting steps to Redgate support but with no resolution. Their suggestion was to post a request here.
We released this feature in SQL Prompt 10.3.3. The only reason SQL Prompt ever needed to query the master database was to get the list of linked servers. If you upgrade to that version and ensure the “load suggestions for linked servers” option is disabled, SQL Prompt should load suggestions correctly.
SQL Prompt Team