You're doing this from .NET? Care to post your code?
Why don't you just do it from Query Analyzer?
~~Bonnie
>Hi Kurt. No triggers at all on the table. No relations to other tables either. In fact, I'm trying to delete all of the records from the table so that I can add a relation.
>
>>Do you have a delete trigger on the table? It sounds like something is trying to update another table (possibly a log table) which is generating the error.
>>
>>Kurt
>>
>>>I'm trying to delete a row from a SQL Server table, but it is giving me an error below. Anyone know how to solve this?
>>>
>>>No Rows Deleted
>>>A problem occured attempting to delete row 1
>>>Error source: .NET SQLClient Data Provider
>>>Error Message: String or binary data would be truncated.
>>>The statement has been terminated.