Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1.
With that said, you should check the following:
- With an open query in SSMS > Edit > Intellisense > Refresh Local Cache (Ctrl + Shift + R)
- SSMS > Tools > Options > Text Editor > Transact-SQL > General : > Statement completion:
- auto list members = checked
- parameter information = checked
- SSMS > Tools > Options > Text Editor > Transact-SQL > IntelliSense > Enable IntelliSense
- With an open query in SSMS > Query > Intellisense Enabled (should already be enabled because of point 3 but just in case...)
- With an open query in SSMS > Query > SQLCMD Mode should be disabled (if you want intellisense to work!) This is what caught me out recently and prompted this post. I had set my queries set to open in SQLCMD mode by default i.e. SMS > Tools > Options > Query Execution > SQL Server > General > 'By default, open new queries in SQLCMD mode' = checked.
If its still not working then try the latest services packs, cumulative updates, installation repair or just turn it off and on again. Good luck. Happy sensing!
