I have found that if use synonyms for tables in SQL 2005 I do not get the intellisense for columns. I typically use these for cross database queries.
Example:
USE Northwind
Create Synonym synAuthors for pubs.dbo.authors
Go
Select * FROM synAuthors a
where a.au_id > 10
--- Note that I get the synAuthors via intellisense but I do not get a column list when I type the a. in the WHERE clause.
I get that this is because of the way synonyms have no meta data column list like a view or table does AND making this cross-database is even more complicated. This is more a new feature request than a bug report.
Example:
USE Northwind
Create Synonym synAuthors for pubs.dbo.authors
Go
Select * FROM synAuthors a
where a.au_id > 10
--- Note that I get the synAuthors via intellisense but I do not get a column list when I type the a. in the WHERE clause.
I get that this is because of the way synonyms have no meta data column list like a view or table does AND making this cross-database is even more complicated. This is more a new feature request than a bug report.