[thelist] 8k Row limits must Go!

[Jonathan_A_McPherson at rl.gov]

> How do I increase the row size in a MS SQL Server 7/2000 database beyond
8k?

Why do you need rows > 8k? AFAIK, there's no way to increase that number.

Some potential solutions:
(1) Store your larger character fields in fields of type "text," which only
use 16 bytes of your row size regardless of the amount of text they contain.
(Text fields have many disadvantages).

(2) Split up your data into two tables with a 1:1 relationship between the
two. You then get almost 16K of row space. You can keep doing this to get
almost arbitrarily large rows (at the expense of query simplicity).

(3) Become a Microsoft(R) partner and get the source code to SQL Server
(R)(TM) under their Shared Source (TM) program. In
"constants/sqlsrvint/limits.c" on line 2455, change:

#define MAX_ROW_SIZE 	8192

to

#define MAX_ROW_SIZE 	8193

or whatever size you need. Recompile.

--
Jonathan McPherson, LMIT/SD&I
Software Engineer & Web Systems Analyst
email / jonathan_a_mcpherson at rl dot gov