This can't be as hard as I'm making it. I want to call a Stored Procedure that has a high degree of encountering an error internally. However, I don't want my app to know that there was an error. Basically, pretend everything was fine, because if the app detects an error it dies.
I tried this, but it's not working.
CREATE procedure HideErrors AS
BEGIN
declare @x varchar
declare @y int
set @x = 'fudge'
set @y = @x + 5
if @@Error <> 0
begin
print 'thats OK'
Return 0
end
END