Maximum number of columns in MS-SQL 2000

[Imaster]

I am using MS-SQL server 2000 and I am getting an error when the number of columns exceed around 1000. In short, I am not able to create more than 1000 columns. Does anyone know the maximum number of columns that can be made?

TIA

[txbakers]

Hi. Don't know your answer, but it seems to me that a table that big would be an anomaly.

Are you absolutely sure you need 1000 fields in a relational table? Have you normalized your database?

I'd look to normalize and spread the wealth (so to speak) before trying to make more columns.

[sun818]

Hi txbakers, agreed. 1,000 is a lot of columns for one table. Might there be a way to combine multiple fields into a single?

It seems 1,024 is the column limit for one base table in SQL Server 2000:
[msdn.microsoft.com...]

[Krapulator]

Sorry, my curiousity gets the better of me. What kind of data are you storing that requires that many columns?

[sharbel]

My goodness why do you have so many columns?

[Slade]

You probably need to rethink your structure. Post some details of it here, <snip>

[edited by: Xoc at 7:33 pm (utc) on Mar. 5, 2004]
[edit reason] snipped [/edit]