Questionaire
Programmer
dear friend,
i am using 3 sql insert in the asp page and all these are to considered as a one transaction.
now i want a method by which if any one of the three insert statement fails the other 2 should get roll back and display a message that transaction failed or else success.
please guide me the steps how i can achieve(either with mts or trigger or any other tech)
hope to get back from you
enjoy and smile always.
bye
i am using 3 sql insert in the asp page and all these are to considered as a one transaction.
now i want a method by which if any one of the three insert statement fails the other 2 should get roll back and display a message that transaction failed or else success.
please guide me the steps how i can achieve(either with mts or trigger or any other tech)
hope to get back from you
enjoy and smile always.
bye