What are the challenges you face when working across database platforms? Take the survey

SQL Prompt Suggestions not Working on SQL 2017

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 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. 


Sign In or Register to comment.