my server os is windows 2003 standarad edition and we installed the sql server 2000 in the os with service pack 4.
our application is developed in visual basic 6.0 and converted as a package and installed in the client system
the problem is when saving the data from the client system it stores the record partially for example i want to store the record in 4 tables from the client system but when saving it stores the record in 2 tables only it is not storeing the record in other two tables
we gave rollback statement in the application but some client system it is rollbacking properly and some client system it is not roll backing the records properly and wise wersa when deleting the records from the client system
i checked the coding thoroughly but in some cases it is not roll backing properly so i need the answer to solve this problem kindly send me the reply to this