While most would be very meticulous about ensuring that their servers are running software with the latest and greatest service/cumulative update packs. However, most developers that I have worked with only deploy a patch if their IT forces them to (via group policies and automatic deployment of updates) or if they face a challenge and the patch resolves the issue. In such a scenario, developers often come up to me and ask this question:
The Intelli-sense feature in the SQL Server Management Studio (SSMS) on my local SQL Server 2008 R2 instance stopped working. Can you fix it?
My reply is always a counter-question: “What changed?”
After the denials, they finally admit that they installed Visual Studio 2010 SP1 and that resolves the issue. After Visual Studio 2010 SP1 is installed on a workstation with SQL Server 2008 R2 (any release from RTM to CU6), the Intelli-sense feature in the SQL server Management Studio (SSMS) may stop working.
This is a known, documented issue with Microsoft (KB2531482)and the fix is quite simple – deploy the latest service pack/cumulative update of SQL Server 2008 R2. To know about the latest available build of SQL Server, please refer my post: http://bit.ly/SiOVIw.
Here are some other posts about Intelli-sense that you may be interested in:
- Enable/Disable Intelli-sense [by Madhivanan (Blog)]: http://beyondrelational.com/modules/2/blogs/70/posts/10965/exploring-ssms-enabledisable-intellisense.aspx
- Intelligent Use of Intelli-sense [by Madhivanan (Blog)]: http://beyondrelational.com/modules/2/blogs/70/Posts/18053/intelligent-use-of-intellisense.aspx
- Intelli-sense and hyperlinks: http://bit.ly/VR4qbF
- Intelli-sense Completion mode: http://bit.ly/VdlXw6
- Intelli-sense uses a “LIKE” search from SQL 2012 onwards: http://bit.ly/10HBo23
Until we meet next time,