Henk van den Berg (8/8/2011)
Very insightful article. Thanks.I have one question, how do you discard the output?
(Anticipating a "slap-to-the-forehead" moment, but asking anyway...)
Best,
Henk
Heh... no problem, Henk. A lot of people miss it. In SQL Server 2005, start by selecting {Tools}{Options}{Query Results}{Results to Grid}. Then, click the {Discard results after execution} check box. In 2005, you may have to open a new query window in SSMS before the setting takes affect. In 2008, (IIRC) the setting is good for the current window and any new windows you open while the box is checked.
--Jeff Moden
Change is inevitable... Change for the better is not.