Hi guys and gals.

Just wanted to know why in ms sql 2000 this line would be allowed to compile

if @@error <> 0 begin set goto Error_Done end

We notice this error when we migrated to ms sql 2005 and did some compatibilty testing.

Changed code to

if @@error <> 0 goto Error_Done for the sp to run.