Click here to Skip to main content
12,549,927 members (44,755 online)
Rate this:
Please Sign up or sign in to vote.
I am getting an error like "The identifier that starts too long. Maximum length is 128" when I try to execute this Stored procedure. Pls Help

exec FC_SchoolContact_Search "main.FirstName LIKE 'School%' AND
 main.CountryCode = 'FR' AND main.StatusCode = 'AC' AND main.Contact_id Not In
(Select BookingSchool_id From Booking wb Where wb.ProductCode = 'SCH' And
 BookingSchool_id  = main.Contact_id) ","bc.ProductCode = 'SCH'",null,null,null
Posted 4-Dec-11 22:51pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

This means that the value you are inserting is too large to the size of the column type. For ex, your table has column id and name wherein name is varchar(10) then you input 20 characters.

cheetu2810 28-Apr-14 8:41am
I amd facing the same problem and my column input are not incorrect form.. :(

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.161021.1 | Last Updated 5 Dec 2011
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100