Error Received:
Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
SQL Server 2000 supports table with maximum 1024 columns. This errors happens when we try to create table with 1024 columns or try to add columns to table which exceeds more than 1024.
Fix/Solution/WorkAround:
Reduce the number of columns in the table to 1,024 or less.
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
3 Comments. Leave new
But the columns in the table are 10 they are not even close to 1024……
Can you reply ASAP
Charles
Charles,
I have been plauged by this issue as well, my table only had 3 columns and when the Alter statement came up, I was getting the exceeds the maximum columns (sql 2K). The alter statement is in a stored proc that gets run by the app frequently. The proc drops the column before it exits, but still…
It was hair raising…
The fix was to script the table, then drop it, and then recreate the table. In my case the table did not have any data in it, so I didn’t have to worry about repopulating it once it was recreated.
Hope that helps,
Mark
this is not the solution. what if table contains lots of data and my table has just 60 columns. please provide proper solution.