Friday, March 9, 2012

EXCEPTION_ACCESS_VIOLATION when I want to update

Hi,

I want to update a db-column with text-format.
The order is simple: Update tblatt set textattvalue = '...' where Attid= ...

... stands for a text and an ID.

I get the exception I wrote in the subject and I don't know, what I can do.
On 3 other Databases, which I create with the same script(=they are all equal), everything works fine.

I hope anyone has an idea.if the transaction is stuck in the log the table will be locked and then you are stuck! Does this still happen if you stop and re-start the sevices?

(Of course you could always look at the table locks :rolleyes: )|||I had restarted the Services before, but it didn't change anything. I deleted the database (only this one, because there are 2 or 3 other important dbs) and recreated it, but nothing changed.

No comments:

Post a Comment