limits imposed by SQL Server SQL Server 2016 and newer well, we max out at 999 SQL Server 2016 and newer well, we max out at 999 max 65k max 65k well, we max out at 999 max 65k we can have maximum 1024 columns SQL Server 2016 and newer