• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Can the max number of columns for a table in MSSQL 2000 be set to over 1024?

I have checked some online books for SQL and queried EE to find out if there is away to increase the max number of columns that are allowed in a table in MSSQL 2000.   Apparently the limit is 1024.  I'm wondering if that is a default value that can be increased?

Thank you.
0
BladesAway
Asked:
BladesAway
  • 3
1 Solution
 
ptjcbCommented:
It is 1024 and it is not user-configurable.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Just out of curiosity, what are your requirements which need more than 1024?
I'm sure there will be a work-around.
0
 
ptjcbCommented:
You would have to break the base table into several smaller tables that do fit the requirement - sort of like vertical partioning. This link will give you some good ideas: http://www.sqlteam.com/Item.ASP?ItemID=684

You will also have to deal with the page size in SQL - it is 8K, with about 8,096 available for a row. You cannot have a row that spans pages.
0
 
ptjcbCommented:
Sorry, the maximum size of a single data row is 8060 (some of the bytes are used as a header) - that is why you will see maximum bytes in a row as 8060. That also is not user-configurable and based on the size of the data page within SQL.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now