From the Microsoft Dynamics GP Blogs: IntelliSense Problems; Integration Manager Oddities; Support Debugging Tool Release

SQL Server Management Studio IntelliSense Doesn't Work: That's what Steve Endow, owner of Precipio Services, writes at Dynamics GP Land.

Endow says he's recently worked on several Dynamics GP SQL Server 2008 servers where the IntelliSense feature in SQL Server Management Studio wasn't working. Here's what he says:

"I would type "SELECT * FROM RM", expecting to get a list of RM tables, but nothing would happen. Ever since I noticed the problem at a client, I seem to notice it happening all of the time, even on my own development servers, where I know IntelliSense normally works.

It seems that there are at least two general causes of this issue.  In the first case, for some reason the IntelliSense "local cache" has an issue or isn't setup.  To resolve that, try and refresh the IntelliSense cache by going to Edit -> IntelliSense -> Refresh Local Cache.

After choosing this menu option, wait several seconds, and then try typing a query to see if IntelliSense starts working.  That seems to work for me most of the time.  I don't know why I have to do it occasionally on my SQL Servers, but it's easy enough."

Endow points out another reason for the problem and offers a couple fixes, although he says they don't seem to work for him. But he says you can try them if his solution doesn't work for you.

Check out his post here.

Bizarro World: Integration Manager "use input" Doesn't Work: Here's a case of something else not working.  Jen Kuntz, the author of a blog post ...