Prevention of user submitting twice should be handled at application level. This is the best way of doing it. I do not think handling it at database level would help your cause. You may end up with something undesired.
answered Aug 08 '12 at 05:18 AM
You're saying that you want to execute the procedure two times? Then I would either execute it twice or just run the command within it two times.
answered Aug 07 '12 at 07:20 PM
Grant Fritchey ♦♦