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, 2012 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, 2012 at 07:20 PM
Grant Fritchey ♦♦