estimating maximum row size

hi,
give a table definition, how can i estimate the maximum row size ?
eg:
table (a varchar(8000),
b varchar(100))
the row size (from the column lengths) is 8100, but actually it is more than
that.
i know that coz when i create the above table i get an error as:
Warning: The table 'size_test' has been created but its maximum row size
(8125) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE
of a row in this table will fail if the resulting row length exceeds 8060
bytes.
i would like to check against this limit. that is why i need the max row size.
thanks
--
Vivek T S
Member Technical Staff (Inucom)Hello,
Check the following link
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/architec/8_ar_ts_8dbn.asp which gives
the max size per row as 8060 bytes.
I would sugest you change your varchar to something like a
text for some other large object. The reason is that they
can store a lot more than 8060 and still be on the same
table as other fields.
Peter
"Happiness is nothing more than good health and a bad
memory."
Albert Schweitzer
>--Original Message--
> hi,
> give a table definition, how can i estimate the
maximum row size ?
> eg:
> table (a varchar(8000),
> b varchar(100))
>the row size (from the column lengths) is 8100, but
actually it is more than
>that.
>i know that coz when i create the above table i get an
error as:
>Warning: The table 'size_test' has been created but its
maximum row size
>(8125) exceeds the maximum number of bytes per row
(8060). INSERT or UPDATE
>of a row in this table will fail if the resulting row
length exceeds 8060
>bytes.
>i would like to check against this limit. that is why i
need the max row size.
>thanks
>--
>Vivek T S
>Member Technical Staff (Inucom)
>.
>sql

Escape Character

Does anyone know if there is an escape sequnce you can use in Report
Definition Language? Some data I'm including inside of a tag contains the
'>' character, and it appears to be confusing things. I'd like to retain that
character by escaping it.
Thanks.Have you installed SP1? I can include the character without trouble...
"Darin" wrote:
> Does anyone know if there is an escape sequnce you can use in Report
> Definition Language? Some data I'm including inside of a tag contains the
> '>' character, and it appears to be confusing things. I'd like to retain that
> character by escaping it.
> Thanks.|||Ok, I typed the wrong character. It is the '<' character, not the '>'
character.
Yes I have SP1 installed.
"Mary Bray [SQL Server MVP]" wrote:
> Have you installed SP1? I can include the character without trouble...
> "Darin" wrote:
> > Does anyone know if there is an escape sequnce you can use in Report
> > Definition Language? Some data I'm including inside of a tag contains the
> > '>' character, and it appears to be confusing things. I'd like to retain that
> > character by escaping it.
> >
> > Thanks.