• Is there a reason that you are using a severity level of 1. Severity levels less than 11 are for informational purposes and this may be causing some of the things that you are seeing. The 16 in your Raiserror is where the <state> goes. This <state> does not seem to do much.

     

    I hope this helps

    Eric