>>>The record is there and the name of the database is correct. And I tried it with another PK value but with the same result. Record is never deleted. Strange.
>>
>>
>>HOW about @@TRANCOUNT?
>
>Sorry for ignorance, but where do I put this line, right after the DELETE command?
Does not really matter, just add
SELECT @@TRANCOUNT either before or after that delete command.
If it's not broken, fix it until it is.
My Blog