SSMS 2008 Intellisense reports Invalid Column Name with text in double quotes and SET QUOTED IDENTIFIER off - by 509Geronimo

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 513941 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/24/2009 9:22:22 AM
Access Restriction Public


I upgraded from SQL 2005 Express to SQL 2008 Express (SP1).  I have T-SQL code with a field value in double quotes (see ex. below).  With ANSI SET QUOTED IDENTIFIER off and Intellisense enabled, I still get the double-quoted field values underlined as errors with the message "Invalid column name".  At the very least, the expected behavior is that with SET QUOTED IDENTIFIER off the field value will not be interpreted as a column name.

Ex.  SELECT "text_" = "<xwidget section='HeadingSection' value='Codes' />"

FYI - the result set is being processed by an HTML template-style DLL that renders web pages from the SQL results.
Sign in to post a comment.
Posted by Microsoft on 12/28/2009 at 11:36 AM

Thank you very much for the input and feedback. We are currently in the process of investigating this issue and evaluating the impact of the change, in order to try and release a fix for this.

We will keep this thread open and update it once we have additional relevant information.

Thank you again for the great feedback!