Hi Clint

Query analyser will be using an ODBC connection, have you got ODBC tracing on?

Are you returning both sets of results to grids/text?

Have you compared the query plans?

Are these on the same machine?

John

"Clint Good" wrote:

> Hi
>
> If I run a simple "select top 10000 * from table" query against a SQL
> 2005 server from a client pc using management studio the query returns
> in about a second. Running the same query on the same client pc using
> the older query analyzer takes 25 seconds.
>
> Does anyone know why/how this could happen ?
>
> Do the two applications connect to SQL using different mechanisms ?
> (Both QA and MS connect using windows authentication)
>
> Regards
> Clint.
>