I believe that when you return rows through EM, it begins return rows immediately, fetching more rows in the background.

Starting with the basics, can you issue a query in QA that returns just one or a few rows? How big is your table. In a C/S environment, you would rarely return all rows form a tx table.

Understand that when you return all rows, it is going to be a full table-scan. i.e., no optimization and no indexs (unless I suppose the fields you are returning are all found in an index).

FWIW, based on your facts, while there is likely a "problem", it does not rest with SQL Server.


>Hi Guys,
>
>I am having a very strange problem. When I run a query in enterprise manager(server machine,open table, return all rows, click on sql button and type the query there) it runs super fast. When i run the same query in the query analyzer on the server machine it hangs. This also happens If i run this query from a VFp Client or .net. it just hangs. can someone help me.
>
>The Sql server is running on Windows 2003, 1 gb mem, 300 gb hdd.
>The LDF file is 110 GB
>the MDF File is 17 GB. No backup of the transaction log has ever been run. The IT Manager only let me know this 1 day ago.
>
>TIA.