sql server - Maximum row size of 8060 Error -
i stuck , can not figure out. have ideas? appreciate help. i have table in sql server 2008 following defintion: i can insert/delete/update without error. however, when run select statement filter out 1 single item, got following error: msg 511, level 16, state 1, line 1 cannot create row of size 8104 greater allowable maximum row size of 8060. if remove condition a15.member_parent_level_id4 in (91329) ran fine. if add 5 or 10 criterias ran fine, including 1 throwing error if add itself. [mstr_prod_hier_id] [int] not null, [mstr_prod_hier_desc] [varchar](50) null, [member_group_level_id1] [int] null, [member_group_level_desc1] [varchar](60) null, [memberkey_sort1] [int] null, [member_group_level_id2] [int] null, [member_group_level_desc2] [varchar](60) null, [memberkey_sort2] [int] null, [member_group_level_id3] [int] null, [member_group_level_desc3] [varchar](60) null, [memberkey_sort3] [int] null, [member_level_id4] [int] null, [member_level_desc4] [varchar](60) n...