Msg 511, Level 16, State 1, Line 1
Cannot create a row of size 8104 which is greater than the allowable maximum row size of 8060.
How to resolve this error in SQL Server 2008?
Asked
Active
Viewed 1,070 times
1
TheGameiswar
- 27,855
- 8
- 56
- 94
Hitendra Deriya
- 31
- 6
-
1Make your rows **smaller** than 8060 bytes for each entry .... – marc_s Oct 13 '16 at 10:29
1 Answers
0
This fails:
create table dbo.test
(
id char(4000),
id1 char(4100)
)
This works
create table dbo.test
(
id char(4000),
id1 varchar(4100)
)
The issue here is Fixed length data types are restricted to maximum of 8060 bytes (2012) per row. Use variable size data types to overcome this restriction
marc_s
- 732,580
- 175
- 1,330
- 1,459
TheGameiswar
- 27,855
- 8
- 56
- 94
-
-
1yes ,you can .but only use when it is necessary ,but check this :http://stackoverflow.com/questions/7141402/why-not-use-varcharmax – TheGameiswar Oct 13 '16 at 10:33
-
-
-
1@HitendraDeriya, the number of columns in SQL Server tables is normally limited to 1024, unless you use wide tables (sparse columns). Having so many columns in a relational database table is a design issue. – Dan Guzman Oct 13 '16 at 11:28
-
@DanGuzman I use wide table (sparse columns), but there i get error like – Hitendra Deriya Oct 13 '16 at 11:55
-
@DanGuzman I use wide table (sparse columns), but there i get error like "Cannot create a row that has sparse data of size 8045 which is greater than the allowable maximum sparse data size of 8019" – Hitendra Deriya Oct 13 '16 at 11:56
-
@HitendraDeriya, there is still a rowsize limitation with sparse columns, but it depends on the number of non-null values. The workaround is to fix the design. – Dan Guzman Oct 13 '16 at 12:14
-
@HitendraDeriya:You need to ask new question,not ask continuously on same question – TheGameiswar Oct 13 '16 at 13:11