CODEWITHSUNDEEP
intellisensedatabase-schemasql-server-2016
Merin Nakarmi
Merin Nakarmi

Reputation: 3418

SSMS Intellisense works for some schema and does not work for other

I have a remote SQL Server 2016 database and SQL Server Management Studio 2016. The database already had some schemas for which intellisense works perfectly. I created a new schema and few tables under the new schema. For this new schema, intellisense does not work at all. After creating new schema, intellisense works for schemas which were already there. I have ensured that the intellisense is enabled at 

Tools > Options > Text Editor > Transact-SQL > Intellisense > Enable Intellisense

I have also refreshed the local cache by hitting

Ctrl + Shift + R

on keyboard and clicking 

Edit > Intellisense > Refresh Local Cache

several times. It is really strange why intellisense does not work only for one particular schema.

Thank you for your help in advance.

Upvotes: 0

Views: 3415

Answers (1)

Merin Nakarmi
Merin Nakarmi

Reputation: 3418

Just as a hit and trial under following menu item, 

Tools > Options > Text Editor > Intellisense

I changed Maximum script size from 1 MB to Unlimited. And it worked like a charm.

Upvotes: 3

Related Questions