Re: SQL Server Deadlock on Insert

2010-08-08 Thread Simon Haigh
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

SQL Server Deadlock on Insert

2010-08-08 Thread tonywr
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