I have looked at the log and found that an index was causing the deadlock. As my SP did not involve any transactions, I found the client code and...

Thanks for quick replies

I will try and reproduce the error (beginning of next week). I have switched on the 1222 flag as mentioned and hope to be able to post...

Thanks for the replies guys. It was this kind of discussion I was hoping for when posting. I have looked at the OUTPUT command and found it quite useful. Although...

WO (11/25/2010)

---

You don't need a cursor to make this work, if you copy the project (insert into project (columns except identity column) select (columns except identity column) from project where...