question

your create statements are different in the first two IF's SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)) IF CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)) LIKE '8.%' CREATE TABLE #ErrorLogData ( TextData VARCHAR(2000) , [Contin] VARCHAR(10) ) GO IF CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)) NOT LIKE '8.%' CREATE TABLE #ErrorLogData ( [EntryDateTime] VARCHAR(2000) , [ProcessInfo] VARCHAR(100) , TextData VARCHAR(2000) ) GO I would correct this and then test again. certainly the parser would have difficulty working out how to insert into a column that may of may not exist. You may be able to get around this by using different tables that have different structures rather than re-using the same name. [Edit] It was lunchtime so I got a version that works on 2000, 2005 + 2008 (but test it yourself too) -- make sure objects dont exist IF OBJECT_ID('tempdb..#ErrorLogData1') > 0 DROP TABLE #ErrorLogData1 ; IF OBJECT_ID('tempdb..#ErrorLogData2') > 0 DROP TABLE #ErrorLogData2 ; -- test for version, create table, insert data and select resultset IF CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)) LIKE '8.%' BEGIN RAISERROR('Found 8',1,1,1) WITH NOWAIT CREATE TABLE #ErrorLogData1 ( TextData VARCHAR(2000) , [Contin] VARCHAR(10) ) INSERT INTO #ErrorLogData1 EXEC sp_readerrorlog ; SELECT TextData FROM #ErrorLogData1 WHERE ( TextData NOT LIKE '%0 errors%' AND TextData NOT LIKE '%0 transactions%' ) AND ( TextData LIKE '%[1-9]%occurence(s) of IO requests%' OR TextData LIKE '%transactions rolled%' OR TextData LIKE '%fail%' OR TextData LIKE '%error%' OR TextData LIKE '%cannot%' /*OR TextData LIKE '%bypass%'*/ ) END ELSE BEGIN RAISERROR('Later than 8',0,0,1) WITH NOWAIT CREATE TABLE #ErrorLogData2 ( [EntryDateTime] VARCHAR(2000) , [ProcessInfo] VARCHAR(100) , TextData VARCHAR(2000) ) INSERT INTO #ErrorLogData2 EXEC sp_readerrorlog ; SELECT EntryDateTime , TextData FROM #ErrorLogData2 WHERE ( TextData NOT LIKE '%0 errors%' AND TextData NOT LIKE '%0 transactions%' ) AND ( TextData LIKE '%[1-9]%occurence(s) of IO requests%' OR TextData LIKE '%transactions rolled%' OR TextData LIKE '%fail%' OR TextData LIKE '%error%' OR TextData LIKE '%cannot%' /*OR TextData LIKE '%bypass%'*/ ) END -- tidy up IF OBJECT_ID('tempdb..#ErrorLogData1') > 0 DROP TABLE #ErrorLogData1 ; IF OBJECT_ID('tempdb..#ErrorLogData2') > 0 DROP TABLE #ErrorLogData2 ;