Error Message with Sql Server 2000 Stored Procedure

[saw15]

I am trying to run a sp and getting the following error message:

A RETURN statement with a return value cannot be used in this context.

IF @@ERROR <> 0
BEGIN
RAISERROR('Error on updating history_load_log_reject, error number %d',15,1,@@error)
RETURN @@ERROR
END
GO

Any assistance / thoughts as to why would be appreciated.

 

[MikePP]

Hi

Your code appears OK to me

Try

IF @@ERROR <> 0
RETURN @@ERROR

and see if you still get the error

Regards

sadcow

 

[saw15]

Just tried it, still getting the same error. I can tell you that the if portion is not getting executed because the @@error is = 0.

I can remove the @@Error after return and it runs as expected.

Any other thoughts ?

 

[MeanGreen]

Can you please post the entire stored procedure? Did you declare @@ERROR within the stored procedure? @@ERROR is reserved, so if you declare it, then you would get the error when you try to return it.

Hope this helps.

 

[MikePP]

Hi

Try using

Return CAST(@@error as int)

sadcow