SQL Server limits

The maximum number of columns per base table is 1024
The maximum number of columns per index is 16
The maximum number of columns per SELECT statement is 4096
The maximum number of foreign key table references per table is 253
The maximum number of parameters per stored procedure is 1024
The maximum number of characters allowed for a table name is 128
The maximum number of characters allowed for a column name 128
The maximum number of columns in the view is 250