Tony
Something I've seen several times:
The table doesn't have a trigger to update the row with a datetime stamp
on row insert/modify.
Simon
On 9/08/2010 9:47 AM, ton...@tpg.com.au wrote:
Hi all,
I am currently trying to improve the template code in our stored proc generator.
In the insert
Hi all,
I am currently trying to improve the template code in our stored proc
generator.
In the insert stored proc, there seems to be a lot of code with references to
deadlock detection,
and attempts to re-run the insert if it fails due to a deadlock.
But the insert statement itself has a RO