SQL Server Cases: Table Records


Menu Expand/Collapse Menu

SQL Server 2000 & 2005 have a record length maximums of 8060 bytes. However, there is no warning or indication whatsoever if during table design one adds columns that exceed 8060 bytes. If there's a limit, exceeding the limit should be prevented and there should be a error message or warning. Guess we should count up bytes as we design our tables -- interesting.

SQL Server Cases