SQL Prompt Suggestions not Working on SQL 2017
EdCarden
Posts: 138 Silver 2
in SQL Prompt
I have SQL Server Management Studio 2017 (v17.8.1) and SQL Server Management Studio 2014 (ver12.0.2269.0). I am running SQL prompt 7.5.1.1000 on both SQL Server Mgt Studio Products and both version of SQL Server Mgt Studio are connecting to the same SQL server.
Suggestions works when using SQL Mgt Studio 2014 but not when using SQL Server Mgt Studio 2017. As best as I can tell I have the options for SQL Prompt set identically in each SQL Server Mght Studio. Why are suggestions working with the older SQL Server Mgt Studio product?
One last note, even though the SQL Server hosting the DB's I am connecting to is SQL Server 2016 the DB's are set to a compatibility level of 2012.
Suggestions works when using SQL Mgt Studio 2014 but not when using SQL Server Mgt Studio 2017. As best as I can tell I have the options for SQL Prompt set identically in each SQL Server Mght Studio. Why are suggestions working with the older SQL Server Mgt Studio product?
One last note, even though the SQL Server hosting the DB's I am connecting to is SQL Server 2016 the DB's are set to a compatibility level of 2012.
Tagged:
Answers
I'm afraid Prompt 7 doesn't support SSMS 2017
https://documentation.red-gate.com/sp7/requirements
Tianjiao Li | Redgate Software
Have you visited our Help Center?