I checked the obvious: Troubleshooting Intelli Sense (SQL Server Management Studio) reconfirmed what I already knew and didn't help. This is not a duplicate because while other forum posts list the above steps as "answers" they are not answers for me.
@Max Vernon -- By intermittent, I mean that on the same computer, while working on a script Intellisense is working.... You can certainly refresh the intellisense cache to get around that; however you need to be aware it may take a minute or two for the refresh to be visible.Pinal is also a Cross Fit Level 1 Trainer (CF-L1) and Cross Fit Level 2 Trainer (CF-L2).For any SQL Server Performance Tuning Issue send email at [email protected] The user has access master db with db_owner role but it's not sysadmin. But it not working with windows authentication user.Intelli Sense can be a very powerful ally for the T-SQL developer.It can significantly reduce keystrokes, prevent you from guessing at object names, make sure you spell them correctly (and use the right case), and can help you understand the interface to several programmable entities such as stored procedures and built-in functions.Another is where the completion list appears, but it does not contain the object(s) you're trying to use.SQL Server 2012 Books Online outlines a variety of other potential issues in the topic Troubleshooting Intelli Sense (SQL Server Management Studio).The cache is refreshed asynchronously in another session.It sounds like two separate intellisense behaviors are perhaps being discussed in the comments. The discussion is around refreshing the cache in the case of schema changes, but "not working" could also just mean the intellisense dialog intermittently doesn't appear at all when it should. It's still supported to use it against SQL Server 2014 (in fact, it's supported to use it against instances as old as SQL Server 2008).