rpb1001
asked on
Cannot create a row of size 8104
Can anyone shed some light on this error. Sounds obvious but...using trim(str, 1200) on the long str.
Thanks!
==========================
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8104 which is greater than the allowable maximum of 8060.
EXECUTE sp_insert_project
@GlenprojectID_2 ='02044952',
@heading_3 ='Leisure Club',
@siteAdd1_4 ='Durham County Cricket Ground',
@siteAdd2_5 ='Riverside',
@siteAdd3_6 ='',
@town_7 ='CHESTER-LE-STREET',
@county_8 ='County Durham',
@postcode_9 ='DH3 3QR',
@applicationID_10 ='02/00312/F',
@value_11 ='3.400',
@primaryCategoryDescID_12 =1523,
@devtTypeID_13 =1,
@projectSize_14 ='L',
@contractStageID_15 =41,
@planningStageID_16 =21,
@prodHist1_17 ='02/12/2002',
@prodHist2_18 ='02/09/2003',
@ContractPeriod_19 ='9',
@Storeys_20 ='2',
@floorArea_21 ='2000',
@siteArea_22 ='',
@units_23 ='1',
@descriptionText_24 ='Scheme comprises construction of a 2 storey health and fitness club, including a gymnasium, solarium, swimming pool, changing rooms, creche, pub/restaurant, sports arenas/halls and office space. Associated works include car parking facilities, access, sewer systems, infrastructure, enabling, landscaping works, service engineering and security measures. Construction - block, brick, internal partitions, tile hanging walls; carpets, insitu concrete, raised access, tiled floor; pitched roof; double glazed windows; fire, timber doors; pad foundations; portal, steel frame; black top surfacing, drain covers, kerbing, planting, road drainage, street lighting, turfing/grass, white lining site works; bathroom, fire alarm system, kitchen, suspended ceilings fittings. An application (ref: 02/00312/FUL) for Detailed Planning permission was granted by Chester-Le-Street D.C. Please note addition of mechanical contractor.',
@tenderText_25 ='Site No. 0191 389 2576',
@dateAdded_27 ='24 Apr 2003 21:38:00',
@contract_Text_28 ='Site No. 0',
@local_authority_29 ='Chester-Le'
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8104 which is greater than the allowable maximum of 8060.
Thanks!
==========================
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8104 which is greater than the allowable maximum of 8060.
EXECUTE sp_insert_project
@GlenprojectID_2 ='02044952',
@heading_3 ='Leisure Club',
@siteAdd1_4 ='Durham County Cricket Ground',
@siteAdd2_5 ='Riverside',
@siteAdd3_6 ='',
@town_7 ='CHESTER-LE-STREET',
@county_8 ='County Durham',
@postcode_9 ='DH3 3QR',
@applicationID_10 ='02/00312/F',
@value_11 ='3.400',
@primaryCategoryDescID_12 =1523,
@devtTypeID_13 =1,
@projectSize_14 ='L',
@contractStageID_15 =41,
@planningStageID_16 =21,
@prodHist1_17 ='02/12/2002',
@prodHist2_18 ='02/09/2003',
@ContractPeriod_19 ='9',
@Storeys_20 ='2',
@floorArea_21 ='2000',
@siteArea_22 ='',
@units_23 ='1',
@descriptionText_24 ='Scheme comprises construction of a 2 storey health and fitness club, including a gymnasium, solarium, swimming pool, changing rooms, creche, pub/restaurant, sports arenas/halls and office space. Associated works include car parking facilities, access, sewer systems, infrastructure, enabling, landscaping works, service engineering and security measures. Construction - block, brick, internal partitions, tile hanging walls; carpets, insitu concrete, raised access, tiled floor; pitched roof; double glazed windows; fire, timber doors; pad foundations; portal, steel frame; black top surfacing, drain covers, kerbing, planting, road drainage, street lighting, turfing/grass, white lining site works; bathroom, fire alarm system, kitchen, suspended ceilings fittings. An application (ref: 02/00312/FUL) for Detailed Planning permission was granted by Chester-Le-Street D.C. Please note addition of mechanical contractor.',
@tenderText_25 ='Site No. 0191 389 2576',
@dateAdded_27 ='24 Apr 2003 21:38:00',
@contract_Text_28 ='Site No. 0',
@local_authority_29 ='Chester-Le'
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8104 which is greater than the allowable maximum of 8060.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the defined length is more than 8060 characters but some of the fields are varchar or similar variable length fields, you can create the table. However, you will not be able to insert a row of data that combined has more than 8060 characters. The Microsoft article I quoted explains this in more detail.
ASKER
thanks
ASKER
So is it just the fact that the potential defined lengths of the datatypes in all off my columns are too big, rather than the data itself?
Will just try reducing the number of characters in the text field - if not will do what you say. thanks.
Will accept this as answer but, just let me know y or n to above question.
Thanks