Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can we configure Maximum Row Size?

Status
Not open for further replies.

desi2002

Programmer
Jan 4, 2002
24
IN
In SQL server 2000, mAximum Bytes per row is 8060
Can we modify this value? Pl help
 
No you cannot. If you need more than this consider if one or more of your fields could be changed to text or nxt datatypes. another strategy is to create another tabble for the additional fields and set up a relationship to the first. It would be a one-to one relationship rather than a one to many.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top