When IntelliSense is not work, it's probably because of one of those reasons:
- You are connected to SQL Server 2008 Edition and above - even if you work with SSMS 2008 - there is no IntelliSense to MSSQL Editions under 2008.
- Check that Intellisense is enabled, look at Query-->Intellisense Enabled, or at Tools-->Options-->Text Editor-->Transact-SQL-->Intellisense, and check there that the 'Enable Intellisense' checkbox is checked.
- Maybe IntelliSense should be refreshed with the latest changes. When restart the SSMS, IntelliSense is refreshed. In order to refresh it while working, go to Edit-->IntelliSense-->Refresh Local Cache.
- If one or more databases is Offline - IntelliSense is not work for all of the databases in the server.
No comments:
Post a Comment