SQL Prompt is not showing all linked server contents

adonia

SELECT srvname, srvproduct, providername FROM master..sysservers

If there is a link server which has "SQLNCLI10" as provider name, SQL Prompt doesn't support to view it's content.

Is there any option which can activate to view also this link server content?

Brian Donahue

Hello,

SQL Prompt only shows linked servers when the driver name is SQLNCLI or SQLOLEDB.

I have submitted a feature request for this ( SP-3812 ). I think we can assume that a linked server using the SQLNCLI10 driver is also a SQL Server.

georgenarr

Does SQL Prompt support all linked servers yet?  I am using AWS Redshift and the Redshift drivers.  I have reset and rebooted SSMS and prompt does not seem to pick up these server objects (tables).

DustinM

Hello,

Thank you for your inquiry into SQL Prompt. Currently, the SQL servers that are supported outside of the standard SQL Server 2012 - 2022 are below.

https://documentation.red-gate.com/sp/getting-started/requirements

• Azure SQL Database
• SQL Server on Azure VM
• Google Cloud SQL for SQL Server & Virtual Machines
• Amazon SQL Server RDS & Virtual Machines

I will leave the SQL Prompt UserVoice forum here if you would like to suggest this addition to our dev team.

https://redgate.uservoice.com/forums/94413-sql-prompt

Best,

Dustin 

georgenarr

Is AWS Redshift included in the "Amazon SQL Server"?

DustinM

AWS Redshift is a different offering from Amazon SQL Server RDS, the method in which the way data is stored is different between the two platforms and is unfortunetly not currently supported by SQL Prompt.

Best, 

Dustin