The formatting's all off so your post is one long line...

however, if you want to check if your code is successful then @@ERROR should return 0.

If you have several statements in your proc, it's always good practice to capture this in a local variable.