How can we help you today? How can we help you today?

SQL Prompt is not showing all linked server contents

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?
adonia
0

Comments

5 comments

Sort by
  • 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.
    Brian Donahue
    0
  • 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).
    georgenarr
    0
  • 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 


    DustinM
    0
  • georgenarr
    Is AWS Redshift included in the "Amazon SQL Server"?
    georgenarr
    0
  • 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 
    DustinM
    0

Add comment

Please sign in to leave a comment.