| Author |
 Topic  |
|
|
engcanada
Starting Member
14 Posts |
 Posted - 02/15/2009 : 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
USA
28965 Posts |
|
|
engcanada
Starting Member
14 Posts |
Posted - 02/15/2009 : 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 Provider
EROOR MESSAGE: String or binary data would be truncated.
The statement has been terminated. |
 |
|
|
tkizer
Almighty SQL Goddess
USA
28965 Posts |
|
|
engcanada
Starting Member
14 Posts |
Posted - 02/15/2009 : 15:01:08
|
It worked.
Thank you and all the best. |
|
|
|
tkizer
Almighty SQL Goddess
USA
28965 Posts |
|
| |
Topic |
|
Error deleteing a row in SQL 2005
