September 5, 2008 at 11:22 am
Hey guys,
I have a SPROC on a SQL2005 server which works fine when I call it. However, if I call it from a SQL2000 server using the four part name shceme (Exec Server.db.dbo.sproc), I get the following error:
Server: Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '3'.
I'm currently attempting to isolate the issue, but was wondering if anyone has seen this before.
/edit: FYI, the numeral '3' does not occur anywhere in my SPROCs code nor is there any dynamic SQL that could try to execute code with a 3 in it.
---
Dlongnecker
September 5, 2008 at 1:18 pm
How about any child objects (views, triggers, constraints, rules, defaults)?
Chad
September 8, 2008 at 2:04 pm
Hello,
The 3 could be referring to a third column in a table or select statment.
For example,
select 1, 2, 3
from table_xyz
order by 3
The engine will list the first, second, and third columns of table _xyz in column 3 order ascending.
Just a thought.
Regards,
Terry
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply