SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

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 (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

  1. 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

  2. this is not the solution. what if table contains lots of data and my table has just 60 columns. please provide proper solution.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s