We are experiencing deadlocks in our MS-SQL Server 2000 database.
We need to better manage the transactions (insert,update) in our ASP code to make sure that if an issue,error or locked occured when trying to make the transaction inside the database, then the system will handle this properly. Briefly, we want to make sure that Deadlocks never happen again and if there are some, we need to rollback the transaction and try agin until the transaction is successfull.
Briefly, adding Try/catch error handling to prevent deadlocks in the MS-SQL server 2000 database.
Each update, insert in the database must be locked until success.