Workaround for row size limit on SQL server

[akki]

Hi all,
i am creating an ASP.net web appln which was working fine till now but
suddenly I developed a new problem. when i am trying to insert data in
a new row in one of my tables,it gave an error. the table has 1 column
called question description which stores the questions.When i reduced
the size of the question it worked fine. the column is of type ntext
Now, isnt ntext supposed to store large data without worrying about the
row size limit of the SQL server ?
I am short of time and would really appreciate if someone could give me
an easy solution to this problem because there are some questions that
need to be inserted whose descriptions are even larger.

Thank you
Akshay

 

[Fao, Sean]

When i reduced
the size of the question it worked fine. the column is of type ntext
Now, isnt ntext supposed to store large data without worrying about the
row size limit of the SQL server ?

How long are the descriptions? The ntext (national text) data type is
meant to store variable-length Unicode data and has a maximum length of
2^30 - 1 (1,073,741,823) characters. Are your descriptions longer than
that? If so and if you don't require Unicode, you might be able to get
away with switching the data type to text, which has a maximum length of
2^31 -1 (2,147,483,647) characters.

Either way, this is probably a question for a SQL related newsgroup.

Hope that helps,

 

[Octavius]

What error did you get?