Posted by Erland Sommarskog on 12/11/05 23:28

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.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: dynamically trasnpose rows into columns
• Prev in forum: Re: query plan in clear text
• Thread view: Re: query plan in clear text

[Reply to this message]