>Hi Experts,
>
>I have the problem to edit data of a column contained inside a table
>directly using MSSQL Enterprise Manager. This is only happen when the length
>of the data is more than 1000++ characters. Whatever I type into the column
>just couldn't be inserted. Please advice. Thanks.

"Sue Hoegemeier" wrote:

> It's due to a limit set in Enterprise Manager. Enterprise
> Manager wasn't designed to be a data entry tool. You should
> be using Query Analyzer or some other method to modify the
> data.
>
> -Sue
>
> On Tue, 15 Aug 2006 04:29:02 -0700, LBT
> <L**@discussions.microsoft.com> wrote:
>
> >Hi Experts,
> >
> >I have the problem to edit data of a column contained inside a table
> >directly using MSSQL Enterprise Manager. This is only happen when the length
> >of the data is more than 1000++ characters. Whatever I type into the column
> >just couldn't be inserted. Please advice. Thanks.
>
>

>Am I able to edit the data in real time manner using Query Analyzer so that I
>no need to create an SQL update statement to update the column? It's quite
>troublesome when need to modify the data (long string) using update statement
>(eg: change or insert some words to data string using Replace function is
>tedious). Thanks.
>
>"Sue Hoegemeier" wrote:
>
>> It's due to a limit set in Enterprise Manager. Enterprise
>> Manager wasn't designed to be a data entry tool. You should
>> be using Query Analyzer or some other method to modify the
>> data.
>>
>> -Sue
>>
>> On Tue, 15 Aug 2006 04:29:02 -0700, LBT
>> <L**@discussions.microsoft.com> wrote:
>>
>> >Hi Experts,
>> >
>> >I have the problem to edit data of a column contained inside a table
>> >directly using MSSQL Enterprise Manager. This is only happen when the length
>> >of the data is more than 1000++ characters. Whatever I type into the column
>> >just couldn't be inserted. Please advice. Thanks.
>>
>>

"Sue Hoegemeier" wrote:

> The point of using Query Analyzer is that you write the
> statement to update the data. I don't use the Open Table
> part in the object browser of Query Analyzer so I don't know
> if you would hit the same issue as you do in Enterprise
> Manager but you could try that.
> I think in the time people spend trying to do these types of
> updates without writing the SQL, they struggle so long that
> they could have had the SQL written and been done with it!
> Not meaning to be rude or anything with the comment. I think
> you'd be better off in the long run by just writing the SQL.
> When you get used to doing it, it is just as fast as
> anything else, provides you with a script you can save which
> somewhat documents what changes you made, gives you more
> control over exactly what is going to be executed, etc. Lots
> of benefits to going the SQL route.
>
> -Sue
>
> On Tue, 15 Aug 2006 23:40:01 -0700, LBT
> <L**@discussions.microsoft.com> wrote:
>
> >Am I able to edit the data in real time manner using Query Analyzer so that I
> >no need to create an SQL update statement to update the column? It's quite
> >troublesome when need to modify the data (long string) using update statement
> >(eg: change or insert some words to data string using Replace function is
> >tedious). Thanks.
> >
> >"Sue Hoegemeier" wrote:
> >
> >> It's due to a limit set in Enterprise Manager. Enterprise
> >> Manager wasn't designed to be a data entry tool. You should
> >> be using Query Analyzer or some other method to modify the
> >> data.
> >>
> >> -Sue
> >>
> >> On Tue, 15 Aug 2006 04:29:02 -0700, LBT
> >> <L**@discussions.microsoft.com> wrote:
> >>
> >> >Hi Experts,
> >> >
> >> >I have the problem to edit data of a column contained inside a table
> >> >directly using MSSQL Enterprise Manager. This is only happen when the length
> >> >of the data is more than 1000++ characters. Whatever I type into the column
> >> >just couldn't be inserted. Please advice. Thanks.
> >>
> >>
>
>