SQL Prompt and Intellisense Issue

[pinaldave]

Hi,

I have installed SQL Prompt 3.9 on my SQL Server 2009. I have now disabled SQL Prompt and attempting to use default Intellisense but it does not work. I think SQL Prompt has currpted something so Intellisense of SSMS 2008 is nto working.
Any idea?

Regards,
Pinal
_________________
Founder - http://blog.sqlauthority.com
SQL Server MVP

[Matthew Flatt]

This was resolved via support call and the resolution was to enable Auto list members and Parameter information under Tools>Options>Text Editor>Transact-SQL>General
_________________
Matthew Flatt
Test Engineer, HyperBac

[pinaldave]

Thank you for helping me via email.

Great help.
_________________
Founder - http://blog.sqlauthority.com
SQL Server MVP

[end-user]

Unfortunately, I have the exact same issue and the posted recommendation does not solve it. I have SP3.9 and SSMS 2008R2. I disabled SP, but the native intellisense is not recovering. What's my next step?

[mark.payton]

I am having this same problem after uninstalling SQL Prompt 5 in SQL Server Management Studio 2010. Intellisense is enabled and the settings as described are correct, but Intellisense remains disabled.

I have purchased SQL Compare, but had installed SQL Prompt 5 in demo mode. I did not uninstall it before I entered my key, but have done so (twice, since I tried a reinstall) since.

[mvklingeren]

Microsoft Visual Studio 2010 Service Pack 1 kills / breaks SQL Server 2008 (R2) intellisense

With hotfix CU6 (GOOGLE) this was fixed for me, some users report it didnt work and have to wait for CU7

http://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1