Hi,

Found a better way of doing this:

SELECT MAX(DeleteMeID) FROM DeleteMe WITH (HOLDLOCK, UPDLOCK)

This will prevent anyone else INSERTING data into the table until the end of the transaction, BUT crucially...

Hi guys,

I know this is an old post, but I've got some more info.

As you would expect setting isolation level to SERIALIZABLE or using HOLDLOCK or SERIALIZABLE hints on the...