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.
BladesAwayAsked:
Who is Participating?
 
ptjcbConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.