Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: string or binary data would be truncated
Message
From
01/02/2006 11:38:00
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01092111
Message ID:
01092383
Views:
14
This message has been marked as the solution to the initial question of the thread.
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.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform