Row updating error.

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.
JIt 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
J wrote:
> 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
>
-Dave Markle
http://www.markleconsulting.com/blog|||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
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:u5rAbRORHHA.3412@.TK2MSFTNGP05.phx.gbl...
> 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
> J wrote:
>> 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
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog