Posted by Dan Guzman on 06/23/06 11:26

Try removing the double quotes around the statement:

EXECUTE dbname.dbo.spGid
'KFT',
'0000000011,0000000012',
'merch,DSMT',
'2006-02-01 00:00:00',
'2006-02-28 00:00:00'

You might also consider passing date strings in format yyyymmdd so that it's
independent of the DATEFORMAT setting.

EXECUTE dbname.dbo.spGid
'KFT',
'0000000011,0000000012',
'merch,DSMT',
'20060201 00:00:00',
'20060228 00:00:00'


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Pedro" <p_costa@sapo.pt> wrote in message
news:1151059100.954015.291360@c74g2000cwc.googlegroups.com...
> Hi, i'm trying to run a stored procedure:
>
> "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT',
> '2006-02-01 00:00:00', '2006-02-28 00:00:00'"
>
> and gives me this error:
>
> The identifier that starts with
> "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT',
> '2006-02-01 00:00:00', '2006-02-28 00:00:00'"
>
> is too long. Maximum length is 128.
>
> Anyone could help?
>

• Next in forum: Re: SQL Server 2005 and Cursors
• Prev in forum: Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?
• Thread view: Re: The identifier that starts with...is too long. Maximum length is 128

[Reply to this message]