Blog Pages

SQL Server 2008 IntelliSense Does Not Work

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