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

Does SQL Prompt 7.5.1 work with SQL Server 2017?

I installed 17.4 SSMS then installed SQL Prompt 7.5.1.

When I connect to SQL 2017, i consistently get "master failed to load."

Verbose log shows warning...
<servername>.[master]
Cache finished with warnings:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName)
at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at ..(IDataReader )
at RedGate.SqlPrompt.Cache.Population.DatabasePopulator.(SqlConnection , CancellationToken )
at ..()


Log also shows
<servername>.[MyUserDatabase] loading skipped
sKO
0

Comments

4 comments

Sort by
  • FabiolaB
    Hi @sKO,

    SQL Prompt 7.5.1 supports SSMS 17, but it doesn't support SQL 2017 databases. Basic support for connecting to SQL Server 2017 was added on SQL Prompt Version 8.0.1.1383.

    You can install the latest version of Prompt here, in order to get suggestions on the database.

    Hope this helps,
    Kind regards,
    Fabiola

    FabiolaB
    0
  • sKO
    If I upgrade, will that be a trial version that will expire?
    sKO
    0
  • sKO
    BTW - Thank you for the clearly stated answer. I like those!
    sKO
    0
  • FabiolaB
    Hi @sKO ,

    You are right, if you upgrade to the latest version you will start a trial. You will need to have a license when the trial period expires.

    Kind regards,
    Fabiola
    FabiolaB
    0

Add comment

Please sign in to leave a comment.