Thanks for response.

I am not sure how the deadlock graph look like. Is it deadlock.trc files?

Thanks .. Florian Reischl

Can we relay on this method in large transaction environment?

any known issues with method of using the ROW_NUMBER?

One doubt if a row gets deleted and new row...

Thanks a lot...

So I need to specify the identity column while creating the table?

The sequence returned by this method will always be unique?