I have an update trigger that does what it needs to do: update a datefield triggered by an after update trigger.
However, when I edit the contents of a table through SSMS (right-click - Edit top 200 rows) it gives me a message that the row couldn't be committed. The error:
The data in row x was not committed.
Eror message: The row value(s) updated or deleted either do not make the row unique or they alter multiple ows(2rows).
If i disable the trigger an update through the interface works just fine. The same upate through an TSQL update statement works fine when the trigger is activated (and trigger does what it needs to do)
What is causing this behaviour and how can I have ànd the trigger ànd update through the interface? Lots of my updates are queries that contain single quotes so it is easier to paste them than write an update statement to update them)