Handling columns with Nvarchar value

Hai All,
can any one out there help me in the following scenario.
I have a Remarks column in a table which is NVARCHAR field and length set
4000. This column value is set by a SP. Case is that when the remarks grows
beyond 4000 , how will i handle it. The requirement is, that I should not
ignore any remarks value.
Such Larger values how will i handle.
Thanks,
V.Boomessh
Hi
Look at NTEXT datatype in BOL. After NVARCHAR(4000), with SQL Server 2000,
your only option in NTEXT.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Boomessh" <Boomessh@.discussions.microsoft.com> wrote in message
news:61F38371-3BEF-436B-9421-FF37E6C30CF0@.microsoft.com...
> Hai All,
> can any one out there help me in the following scenario.
> I have a Remarks column in a table which is NVARCHAR field and length set
> 4000. This column value is set by a SP. Case is that when the remarks
> grows
> beyond 4000 , how will i handle it. The requirement is, that I should not
> ignore any remarks value.
> Such Larger values how will i handle.
> Thanks,
> V.Boomessh
>
>

hai

i am getting problem from the stored procedure updating the data in to table. It is just displaying me that Data was Not saved. other than that nothing is displayed.
i am not understanding why it is not updating. can u pls help me , what will be the problem for not updating.?Originally posted by pln_verma
i am getting problem from the stored procedure updating the data in to table. It is just displaying me that Data was Not saved. other than that nothing is displayed.

i am not understanding why it is not updating. can u pls help me , what will be the problem for not updating.?

can u post the procedure and the ddl for the underlying tables, so that we can look into the problem?
regards,
Harshal.

Hai

I have a small doubt in Heap

Is heap consists of extents as a whole or heap ma contain a part of
extent1 and a part of extent2

plz me and my friend is fighting for this plz reply me soonThe first extent of a table is mixed and may therefore contain pages used
by different objects. Subsequent extents are uniform and are dedicated to
that object.

See the Books Online <architec.chm::/8_ar_da2_4iur.htm> for more
information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Deva" <devarajan.g@.gmail.com> wrote in message
news:43a9a4c6.0408112109.68861131@.posting.google.c om...
> I have a small doubt in Heap
> Is heap consists of extents as a whole or heap ma contain a part of
> extent1 and a part of extent2
>
> plz me and my friend is fighting for this plz reply me soon