http://www.red-gate.com/products/SQL_Prompt/index.htm
Basically, install it, run query analyzer, type "select * from " and BAM! Full list of tables. Type over the * and BAM!, list of columns and functions. Pretty darn cool!!!
And, its a free download until September 2006!
While it supposedly supports query writing inside of VS2005, I haven't found a way to get this to work.