i'm using storedprocedure, my problem is how can i trap the update and 

delete collision when 2 user access same records.Considering both are 

updating the same records or one is updating while the other one already 

deleted the records.