Hi,

I have a table called "company" which has 12000 rows. I executed a SQL select statement from the Query Analyzer to display the table.

select * from company.

Its displaying all the rows in the table. But the Query is not getting completed. It still shows the RED mark and "Executing Query Batch".
When I use this SQL query from my application. My application hangs.
Can anybody help me in this.
Its very urgent.
Regards
Neeraja

Which version of sql server are you using ? Do you have any indexes on the table ?

SET PAGESIZE 13000