SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns | Journey to SQL Authority with Pinal Dave

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… Continue Reading...

Source: SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns | Journey to SQL Authority with Pinal Dave