Sign in

Microsoft.com

Microsoft

Remove From My Forums

increasing field number limits

Question
0

Sign in to vote

Hi all,

can we increase the maximum no of fields for a form, generally Microsoft allows only 1024 fields for a form.

Thanks in Advance Siva

Wednesday, July 11, 2012 10:10 AM

All replies

1

Sign in to vote
No. The restriction is due to the 1,024 column limit in a SQL Server table:

http://msdn.microsoft.com/en-us/library/ms143432.aspx

This does not appear to have changed with the introduction of SQL Server 2012.
--pogo (pat) @ pogo69.wordpress.com
- Proposed as answer by JLattimerMVP, Moderator Thursday, July 12, 2012 11:40 PM
Wednesday, July 11, 2012 10:20 AM
0

Sign in to vote

pogo69 is correct. The maximum number is 1024 and cannot be increased even if you are using SQL 2012.

Perhaps your scenario can be achieved with less fields and potentially more entities?

-Brandon

Thursday, July 12, 2012 10:03 PM