You can use the OPTION FAST {xrows} query hint. See SELECT in BOL for more info.
-km


-----Original Message-----
From: Jason Volpe [mailto:mssqldba-ezmlmshield-x68709780.[Email address protected]
Sent: Tuesday, June 29, 2004 1:39 PM
To: LazyDBA Discussion
Subject: Results Screen Buffer

Is there a way to have results immediately show on the results panel

rather than having to wait for them to buffer or the query finish?



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 6/27/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 6/27/2004


MS Sql Server LazyDBA home page