improve my => 'code' 
Even if your databases are from prior versions of SQL Server, you should download the new CTP for SQL Server 2008.
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
The new version's SQL Server Management Studio will connect to older versions of SQL Server databases and give you intellisense (almost as good as Red Gate's Sql Prompt!).
Hope this saves you some time,
Jonathan