From SQL Server 2000 Books On Line:
If you enclose a character string that is more than 128 characters in
double quotation marks, the application may receive this error. When the
QUOTED_IDENTIFIERS option is set ON (SET QUOTED_IDENTIFIERS ON), Microsoft?
SQL Server? expects quoted identifiers to be enclosed in double quotation
marks (") and data values to be enclosed in single quotation marks ('). In
the case of character parameters of stored procedures, SQL Server accepts
data values enclosed in double quotation marks if the character string is
less than 128 characters. They should be considered syntax errors by SQL
Server and generate an error.
Does this explain the message you are getting?
Microsoft SQL Server Support
Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
> Content-Class: urn:content-classes:message
> I am getting error 103: "The identifier that started %g is
> too long. Maximum length is 128". The microsoft
> documentation is stating 8000 bytes for such string. I am
> thing that I probably have to set a parameter to adjust
> this. Any suggestion?
> Thank Mehdi