Omer van Kloeten's .NET Zen

Programming is life, the rest is mere details

News

Omer van Kloeten's Facebook profile

Omer has been professionally developing applications over the past 8 years, both at the IDF’s IT corps and later at the Sela Technology Center, but has had the programming bug ever since he can remember himself.
As a senior developer at NuConomy, a leading web analytics and advertising startup, he leads a wide range of technologies for its flagship products.

Get Firefox


powered by Dapper 

.NET Resources

Articles :: CodeDom

Articles :: nGineer

Culture

Projects

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.

Posted: Jan 05 2009, 11:16 AM by Omer van Kloeten | with 3 comment(s)
Filed under:

Comments

Olaf Helper said:

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:

blogs.sqlserverfaq.de/.../Post.aspx)

I tested it and after refresh it works.

# January 6, 2009 7:24 AM

Omer van Kloeten said:

Yeah, that works very nicely. Thanks. :)

# January 7, 2009 2:57 AM

Eddie Beaumont-Thomas said:

I'll second that Olaf.

# May 31, 2009 9:51 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)