I am getting the same error code. i have placed 3 insert statements inside the transaction. the first and the third statement executes correctly individually. but when i comment the 1st and 3rd and try executing the procedure, its shows the message 3902. It shows the theres some fault with teh 2nd insert statement. i have checked all the details of the statement and seems all right to me. What can be the problem ?