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.


7
1
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

Description

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
Hi,

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

Thanks,
Dipti.
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.