SQL Server has a hard limit of 1024 columns per table as shown on this web page. It is not adjustable.
If you have a table which is that wide you may need to look at making the table narrower. Having a table that wide usually isn’t required.
Register Hereor login if you are already a member