I absolutely love Red Gate's SQL tools, and can't say enough good things about them.  I just found out from Steven Smith that Red Gate have purchased Prompt SQL (intellisense for SQL), and there's a beta to be downloaded that supports SQL 2005 Management Studio!  According to the beta support forums, the plan is to sell SQL Prompt for $50/user with multi-user discounts at 5- and 10-user levels.

By the way, Red Gate's Profiler and Load tools are incredible, too.