Hi All,

While accesing tables from the front end sometimes i am getting a Deadlock error even though the
tables accesed dont contain huge data.
Can anybody suggest some ways to resolve this error.
I have checked the fornt end code and its just using a CSP first to update a record and the trying to
select the record to show the updated value on the screen.
CSP is very basic with and update statement and the @@Error and rowcount are perfect.

Thanks in advance.
Jhumu
MS Sql Server LazyDBA home page