"string or binary data would be truncated" when deleting row

user_420824 0
Viewed 13492

Im using Microsoft SQL Server Management Studio Express to connect to our SQL Server 2005 (think its 2005, its version 9.000 something something). I have a table with one column that saves a lot of text. I have set the column type to text. When i have a row with lots of text in this column i cannot delete it. I get the message "string or binary data would be truncated" when i try to delete it. If i try to edit the row i get the same message. What do i do?

Considerable : i fix it by drop table and create it again, but i wanna a Solution!

sql-server sql
5 Answers

I discovered there was a trigger that audited changes to the record (thanks Tomas Vana), but the target audit record had a limited varchar field for the action report (varchar(1000)). It was trying to audit the deletion of records that had varchar(max) fields...duh!

I changed the action report field in the log to varchar(max) and that fixed it... bloody obvious really...:)

user_17228050
Related