Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008
I am getting an error like "The identifier that starts with...is 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
vivektp549

1 solution

Rate this: bad
good
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.
 
Regards,
Eduard
  Permalink  
Comments
cheetu2810 at 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
0 Sergey Alexandrovich Kryukov 547
1 Member 11120668 188
2 ChauhanAjay 180
3 Maciej Los 165
4 CHill60 135
0 Sergey Alexandrovich Kryukov 9,735
1 OriginalGriff 6,987
2 CPallini 5,835
3 George Jonsson 4,017
4 Gihan Liyanage 3,266


Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 5 Dec 2011
Copyright © CodeProject, 1999-2014
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