SET SHOWPLAN (level 2)

Installing SQL Server

Installing SQL Server
SET SHOWPLAN (Level 2)
SQL Server 6.x SQL Server 2000
When SET SHOWPLAN was set ON, SQL Server executed Transact-SQL statements. When set ON, the SET SHOWPLAN_ALL and SET SHOWPLAN_TEXT statements, which replace SET SHOWPLAN, do not execute Transact-SQL statements.

Expect different results as compared to earlier versions of SQL Server. Expect a difference in behavior when SET SHOWPLAN_ALL or SET SHOWPLAN_TEXT are set to ON.