Hi all, I installed SSMS Tools and now my intellisense isn't working. Is there a reset settings, like for VS (devenv /resetsettings)?
+1
A:
If you right click in a the query window there is an option to enable the Intellisense.
What about running
SSMS.EXE /selfreg /setup
in a command prompt
Barry
2010-05-12 07:52:24
Will give it a try and let you know.
Ardman
2010-05-12 07:53:21
Nope. That didn't work either :o(
Ardman
2010-05-12 08:03:20
Also this post may be of some use http://msdn.microsoft.com/en-us/library/ms173434.aspx
Barry
2010-05-12 08:09:25
I have tried the SSMS.EXE command, but it still isn't working. Is there anything else that I can try?
Ardman
2010-05-12 08:41:28
Have you looked at the link I posted?
Barry
2010-05-12 09:09:33
Yes. But still no joy. :o(
Ardman
2010-05-12 09:40:46
Then I'm all out of ideas I'm afraid. Only other option would be to reinstall the client tools. You are connected to a SQL 2008 database aren't you? Intellisense wont work on anything below SQL 2008.
Barry
2010-05-12 10:01:49
Appreciate the help and ideas that you have given me. I will try and repair the installation to see if that helps.
Ardman
2010-05-12 10:12:16
+1 - thanks for your help.
Ardman
2010-05-12 15:08:56
+1
A:
Check two things:
1 - is the Intellisense enabled under Tools > Options:
2 - does refreshihg the local cache help??
marc_s
2010-05-12 07:53:19
+4
A:
Ok, so after all the help from Barry, I had to repair the installation from the DVD and now I have intellisense back. This worked for me, but Barry's may work for others.
Ardman
2010-05-12 12:40:00