Does SQL Prompt 7.5.1 work with SQL Server 2017?

sKO

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

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

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

sKO

If I upgrade, will that be a trial version that will expire?

sKO

BTW - Thank you for the clearly stated answer. I like those!