SQL Server Management Studio IntelliSense not working for subqueries on table-valued functions - by jhhhj

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 465372 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 6/8/2009 1:27:14 PM
Access Restriction Public


In SQL Server Management Studio IntelliSense  when including subquery based  on table-valued function IntelliSense incorrectly marks returned variables as ambigious and marks function as "invalid object name". If table-valued function has an alias then IntelliSense says that "identifier could not be bound". Please see attached screenshots for reference. 
Sign in to post a comment.
Posted by Microsoft on 4/22/2011 at 11:57 AM

Thanks for reporting this issue. We have fixed this issue in the upcoming Denali CTP.

Posted by Adam Chidgey on 3/17/2010 at 4:34 AM
I'm experiencing this problem for Scalar based functions, intellisense doesn't seem to pickup on the fact that I have my own functions it just says: "xxx is not recognised as a built in function name". When I run the query, it all works as expected.

Intellisense seems to display table listings OK, yet not other objects.