>>>
>>>Are you sure you installed the Client Tools?
>>>
>>>BTW, did you tried to search for it (in Windows Vista I can type anything in the Start/Start Search box and find the programs this way).
>>
>>I am not sure if there was a check for Client Tools though. I guess I will go through the install again. Thanks.
>
>As an alternative, you can downoad SSMS for SQL Server 2008 and use it with SQL Server 2005. SSMS has built-in intelligense.

Unfortunately, intellisense in SQL Server 2008 SSMS doesn't work when connected to SQL Server 2005 instance.

See http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/8ec7d6f7-30f4-4439-90bf-1d98f02a6d89