Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error: string or binary data would be truncated
Message
De
01/02/2006 11:38:00
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01092111
Message ID:
01092383
Vues:
13
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform