Posted by Hugo Kornelis on 12/12/05 02:19

On Sun, 11 Dec 2005 21:28:01 +0000 (UTC), Erland Sommarskog wrote:

>Hugo Kornelis (hugo@pe_NO_rFact.in_SPAM_fo) writes:
>> If you use the SET SHOWPLAN_TEXT ON option, the query will actualy be
>> run, unless you also activate the fmtonly option with the commands
>
>No, SET SHOWPLAN_TEXT (and SHOWPLAN_ALL) ON turns off execution:
>
> SET SHOWPLAN_TEXT ON
> go
> PRINT 'Showplan is ON'
> go
> SET SHOWPLAN_TEXT OFF
> go
> PRINT 'Showplan is OFF'
> go
>
>The command to use if you want plans and also execute, is
>SET STATISTICS PROFILE ON.

Hi Erland,

You're right. Thanks for putting me straight.

I guess it's time to write another 1000 lines of "never post without
testing" :-(

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Re: Using muliple smaller SPs and Functions better than using 1 big SP?
• Prev in forum: Re: dynamically trasnpose rows into columns
• Thread view: Re: query plan in clear text

[Reply to this message]