I have installed SQL server 2016 whose details are as in below screenshot:

SQL Server 2016 > About

My queries are pointing to Azure SQL DB.

Below are the screenshot of some other settings that I have found over the internet and applied:

Tools > Options > Text Editor > Transaction SQL > General

Tools > Options > Text Editor > Transaction SQL > IntelliSense

I have also tried by refreshing the local cache and reconnecting to the database.

Please share your expert opinion here and help me to make this work.


1 Answer 1


The setting that made the biggest difference for me was the "Maximum script size", which had to be set to "Unlimited".

SSMS IntelliSense Settings

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.