It sounds like SQL Server is interpreting some of your data as an identifier (field name, table name, etc.). Identifiers in SQL server can be a maximum of 30 characters. If you could post some code from the stored procedure and the code you're using to call it, maybe someone can spot the problem.
>I’m uploading some data form a VFP to SQL 6.5 using a stored procedure that has been tested and we know it works. The error message is “The identifier that starts with ‘A’ is too long. Maximum length is 30.” I know the identifier ‘A’ is the name field and it is 32 character long. Where is the 30 maximum limitation coming from? This field on the SQL server is called firm and is char (60).
>
>Mike