SET PARSEONLY ON/OFF working fine on 2008 but fails on 2005

See more:

SQL-Server-2005

SQL-Server

Hi All,

I am facing an issue while using SET PARSEONLY ON/OFF.

I hv created a SP which checks if a query passed to it is correct or not.
The SP executes fine on SQL Server 2008 but gives an error "A severe error occurred on the current command. The results, if any, should be discarded." on Sql Server 2005 .

The SP is :

CReate PROCEDURE parsetest(@str varchar(8000))
AS
begin
DECLARE @parseonoff AS VARCHAR(50)
BEGIN try

    --PRINT @str
    SET @str = 'SET PARSEONLY ON; ' + @str
    EXEC (@str)
    set @parseonoff = 'SET PARSEONLY OFF; '
    exec (@parseonoff + 'Select 1')

--  FROM dbo.Rostering
END TRY
BEGIN catch
    set @parseonoff = 'SET PARSEONLY OFF; '
    exec (@parseonoff + 'Select 0')
    --SET PARSEONLY off
END CATCH
END

Test Case 1:

DECLARE @str VARCHAR(1111)
--DECLARE @a INT
SET @str = 'SELECT 1'
--SET PARSEONLY ON
EXEC parsetest @str

Test Case 2:

DECLARE @str VARCHAR(1111)
--DECLARE @a INT
SET @str = 'SELECT bbb(1)'
--SET PARSEONLY ON
EXEC parsetest @str

Any help would be much appreciated .

Regards ,
Gopal