Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
engcanada
Starting Member
39 Posts |
 Posted - 2009-02-15 : 10:55:24
|
| Hi,Can someone help with this issue. A large amount of data has mistakenly inserted into a filed type(ntext) of row and when I try to delete or update the row I keep getting a MSSQL error that the "data will be truncated, no data were deleted, fix the errors or press ESC to exit". |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
engcanada
Starting Member
39 Posts |
Posted - 2009-02-15 : 13:25:21
|
| In the SQL Server Management Studio as follows:NO ROWS WERE DELETED.A PROBLEM OCCURED ATTEMPTING TO DELETE ROW 4830.ERROR SOURCE: .Net SqlClient Data ProviderEROOR MESSAGE: String or binary data would be truncated.The statement has been terminated. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
engcanada
Starting Member
39 Posts |
Posted - 2009-02-15 : 15:01:08
|
| It worked.Thank you and all the best. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Error deleteing a row in SQL 2005