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.