Oh thanks!

For 2000 I suppose I could just convert all T-SQL into an nvarchar @Sql and do this:

execute @SqlSuccess = sp_executesql @Sql

if (@SqlSuccess = 0)

begin

--success code

end

else

begin

--fail code

end

Probably the best option?