Re: Key violation and lock violation stop delete query!!

Tech-Archive recommends: Speed Up your PC by fixing your registry

Amit,

Not sure this is the source of your problem, but you could start by losing the DISTINCTROW keyword:

DELETE Receipt.*
FROM Receipt
WHERE [receipt].[receiptNo] = [receipt];

HTH,
Nikos
.