Row updating error.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J - 30 Jan 2007 23:07 GMT

Hello. I'm trying to update some 'text' data directly through SQL Server
Management Studio (2005) on a table and have been encountering the following
error popup:

Microsoft SQL Server Management Studio
No row was updated.

The data in row _ was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.
The statement has been terminated.

Correct the errors and retry or press ESC to cancel the change(s).

This is strange in that I can update some records in regards to this 'text'
field but then on many other records I get the above error? Would be much
appreciative if anyone would be able to shed some light on this.

Thanks in advance.

J

Reply to this Message

Dave Markle - 31 Jan 2007 03:03 GMT

It just means that the values you're entering are too long. Right-click
and choose "Modify" in Mgmt Studio. There, you'll see a list of the
maximum allowable lengths for each of your columns. You can't type in
anything longer than what's specified there.

-Dave

> Hello. I'm trying to update some 'text' data directly through SQL Server
> Management Studio (2005) on a table and have been encountering the following
[quoted text clipped - 17 lines]
>
> J

Signature

-Dave Markle

http://www.markleconsulting.com/blog

Reply to this Message

J - 31 Jan 2007 17:49 GMT

It was strange because there was existing data in these records under the
'text' column already. In trying to update it to a single character I
noticed I received the error messages for records that had lengthy data in
it (like paragraphs long) versus the records that I was able to update that
only had a few characters which I didn't receive the error message and was
able to update it to a single character. Since we're still in the
development stage I ran an UPDDATE statment to set all of this 'text' column
to null and it seems like that this did the trick.

Thanks for your quick reply and info Dave. Much appreciated.

Take care.

J

> It just means that the values you're entering are too long. Right-click
> and choose "Modify" in Mgmt Studio. There, you'll see a list of the
[quoted text clipped - 24 lines]
>>
>> J

Reply to this Message