Nathan, the problem with your scenario is that the SQL form completion event must trigger in order for the SQL to try and insert the record (success or failure). So how do you warn the user? Best and most efficient way in my opinion is through a store procedure:
Create a store procedure to accept the token values, check for datatype/validity of the tokens and if they are valid, insert the record
within the store procedure, also call the "xp_sendmail" to send the user email telling them if the record was inserted successfully or it failed.
Check out the link:
http://msdn.microsoft.com/en-us/lib...89505.aspx concerning how to use xp_sendmail
-- David