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.
Reduce the number of columns in the table to 1,024 or less.
Reference : Pinal Dave (https://blog.sqlauthority.com)