Installing SQL Server
CREATE PROCEDURE (Level 4)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| CREATE PROCEDURE statements failed if they contained a CREATE TABLE or SELECT INTO statement creating a temporary table with the same name as a temporary table that existed at the time the CREATE PROCEDURE statement was executed. | The CREATE PROCEDURE statement succeeds.
Recode any logic that depended on the earlier behavior. |