Thanks for the article.  I too struggled with the options.  I even created an access project for the SQL database and continued to use Access as much as possible.  But It forced me to save every query before executing creating a mess of temp queries.

An even better option is to use the query generator in Visual Studio.  Create a Database Project and keep all your stored procedures and queries there (allows source contorl).  When you open the TSQL code file, you can highlight portions and right-click to build the Query visually.  This is a much better tool, but does not show the output as well as Query Analyzer.

VS2005 has even a better tool.

Dave C.