SQL 2000 Recommended Varchar Size for Comment Column 1

[Auguy]

SQL 2000. I'm splitting out my comment fields from my base tables into their own table to give me more room for comments and to possibly have more than once comment per base record. The largest comment field right now is varchar(5000). I know I don't want to go beyond the row limit of 8060. Is there a recommended size that would make SQL 2000 happy? I will also need an integer PK column and an integer FK column to link to my base tables in this new table.

Auguy
Sylvania/Toledo Ohio

 

[gmmastros]

Each integer is 4 bytes. Varchar maxes out at 8000.

I would use 8000. You still won't exceed the row size, so why not make it as big as possible?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Auguy]

Thanks George!

Auguy
Sylvania/Toledo Ohio