Paul Litwin has pointed out in one of his blog post's that Red Gate's SQL Prompt utility, a great IntelliSense utility for SQL server can be downloaded for free until the next version is released. To download SQL Prompt, visit http://www.red-gate.com/products/SQL_Prompt/index.htm.