>>>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.