> Both QA and MgmtStudio results to text.

Try executing both to grid and compare. Perhaps try with a smaller row number and work upwards and
compare grid/grid vs. text/text to see if there is a smaller difference in grid handling between QA
and SSMS compared to text handling.

I believe that MS did some smarts regarding text handling in SSMS where in QA there was lots of
overhead for "whitespace painting".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Clint Good" <clgood@bigpond.com.au> wrote in message news:exy6sK0kIHA.1052@TK2MSFTNGP05.phx.gbl...
> Hi John
>
>> Query analyser will be using an ODBC connection, have you got ODBC tracing on?
>
> ODBC. Thanks. I've left the office for the day, but I'm almost positive it isn't on. Will check
> tomorrow.
>
>> Are you returning both sets of results to grids/text?
>
> Both QA and MgmtStudio results to text.
>
>> Have you compared the query plans?
>
> Didn't think to as it was just "select top 20000 * from table". I'd be amazed if this was it as it
> is consistenty coming up with one good plan for a MgmtStudio client and one bad one for QA client.
>
>> Are these on the same machine?
>
> Yes. Same machine.
>
> Thanks for your reply
> Regards
> Clint.