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. |