The parser doesn't care about logical processing. It sees the same create temp table and throws up its hands. Maybe you can change your logic a little bit to avoid dynamic sql. In your comments it sounds like you have the same columns in 2005/2008 but with 2012 you need to simply add some columns? If so, just create your 2005 version of the table and then add whatever columns you need for 2012.

DECLARE @ProdVersion VARCHAR(4)

SELECT @ProdVersion = CASE

WHEN SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), 1, 3) = '9.0'

THEN '2005'

WHEN SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), 1, 3) = '10.'

THEN '2008'

WHEN SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), 1, 3) = '11.'

THEN '2012'

END

CREATE TABLE #DBCC_OUTPUT

(

[Error] INT NULL

)

IF (@ProdVersion = '2012')

BEGIN

--Alter the table with extra columns added in 2012

alter TABLE #DBCC_OUTPUT

add YourNewColumn varchar(10)

alter TABLE #DBCC_OUTPUT

add YourOtherColumn int

END