Row size increase....

Hi,
I have large test data. I have face problem with row size greater than 8060
then it give me warning/error. If i want to store in row greater than 8060
then how to do? Is it any possible way? I try with ntext and sp_tableoption
but it gives me upto 256.
And i read in theory BLOB and all but how to use that?
Thanks in advance.
MilindHi
You may want to read
http://msdn.microsoft.com/library/d...r />
_8orl.asp
http://msdn.microsoft.com/library/d...r />
_6zec.asp
There is alot of other information regarding ntext/image in Books online.
John
"Milind" wrote:

> Hi,
> I have large test data. I have face problem with row size greater than 806
0
> then it give me warning/error. If i want to store in row greater than 8060
> then how to do? Is it any possible way? I try with ntext and sp_tableoptio
n
> but it gives me upto 256.
> And i read in theory BLOB and all but how to use that?
> Thanks in advance.
> Milind|||"Milind" schrieb:
> Hi,
> I have large test data. I have face problem with row size greater than 806
0
> then it give me warning/error. If i want to store in row greater than 8060
> then how to do? Is it any possible way? I try with ntext and sp_tableoptio
n
> but it gives me upto 256.
> And i read in theory BLOB and all but how to use that?
> Thanks in advance.
> Milind
There is no way to store more than 8060 bytes in a record (you cannot exceed
the page size with a record). Split the data and spread them to several
tables, connected by a common primary key!
The only exception to that rule are the blobs (images and texts) as they are
stored in a different location and the record contains only a pointer to tha
t
location. A single text field can contain up to 2 GB of text, but requires
only 4 Bytes in your record. But beware: it is not as easy to handle these
fields later (indexing, searching etc.) as it is with 'normal' data fields.|||If your table has one or more varchar columns resulting in a record layout
with a maximum possible size > 8060, then you can ignore the warning so long
as you don't actually submit an insert or update that would store more than
that maximum.
"Milind" <Milind@.discussions.microsoft.com> wrote in message
news:86D1FA64-C1FB-4781-AE05-FB910464A2E2@.microsoft.com...
> Hi,
> I have large test data. I have face problem with row size greater than
8060
> then it give me warning/error. If i want to store in row greater than 8060
> then how to do? Is it any possible way? I try with ntext and
sp_tableoption
> but it gives me upto 256.
> And i read in theory BLOB and all but how to use that?
> Thanks in advance.
> Milind