Update: I guess Intellisense isn't there. It's a mystery. Please give lots of comments so people know we are serious about wanting Intellisense.
I was extremely disappointed when SQL Server 2005 Management Studio and even the text editor for SQL scripts in Visual Studio 2005 did not support Intellisense for database objects. I was incredulous. This is a feature that is probably available in Team Edition for Database Professionals but not in the base IDE. I am shocked that basic editing, source control, and project features afforded other modules in VS2005 is not available to database projects.
However:
red-gate software has stepped into the gap and provided SQL Prompt, which provides Intellisense features in SQL Server 2005 Management Studio and SQL Server 2000 Query Analyser, for free.
Run, don't walk.