开发者

String or Binary DAta would be truncated on Delete

I'm trying to delete a couple of rows

USING

SQL Server management studio, for 2 rows only i get the message

No rows were deleted

A problem occurred attempting to delete row #X
Error Source: .Net SqlClient Data Provider
Error Message: String or binary data would be truncated
The Statement has been terminated


Correct the errors and attempt to delete the row again or press ESC to cancel 开发者_如何学编程the change(s)

What could be happening while deleting the row ?

the keys are unique so that's not an issue

I've deleted the rows using manual DELETE statements but curious about what's going on here

any thoughts ?

this is using SQL 2008 R2 Express edition

UPDATE - there are no triggers on the table


Try running SQL Profiler while deleting through SSMS if you want to know exactly how it's deleting them.

Do you have a delete trigger on the table? It could be that one of the variables that you're logging into an audit table is longer when going through the GUI instead of through the query window.

In any event, providing the table definition and the rows being deleted might help others find a solution to your question.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜