SQL Server Management Studio 2008 IntelliSense Doesn’t Recognize Special Characters

ssms

I just filed a new bug with Microsoft Connect. I certainly hope this one doesn’t get shrugged off like many of my other bugs did.

Want to reproduce it yourselves? Just create a table with a character that can only be valid inside the context of brackets (like a comma or braces) and then try to select from it. Don’t keep the CREATE clauses in the same query window or it might just work. See the screenshot below.

This is very frustrating because this means that not only is there no IntelliSense for these objects, but IntelliSense now gets in the way of actual querying as it will autocomplete incorrect names.

Advertisements

4 thoughts on “SQL Server Management Studio 2008 IntelliSense Doesn’t Recognize Special Characters

  1. Hello Omer,
    it’s only a “half bug”, because it works, but …
    you have to refresh the “IntelliSense local Cache” first.
    You can find it in menu “Edit” => “IntelliSense” => “Refresh local cache” (I guess so, I only have the German version; a screenshot you can find here:
    http://blogs.sqlserverfaq.de/Lists/Beitraege/Post.aspx?ID=92)
    I tested it and after refresh it works.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s