>I have to update more than 5 table ..My all table is free table. How can I ensure transaction completed in all tables successfully. Is any way to use without using database( I mean without using begin transaction..and endtransaction).
>Any programatically trick will be highly appreciated.

Sajjad,

The best way to do this is with transactions, but it seems that you could locate and read back the records you've written and see if they were actually written.