November 9, 2006 at 12:12 pm
I am running SQL 2000 on our Server and I am running 2005 Management Studio on my PC. I tried running an RPC Call command from the 2005 Management Studio and it didn't work.
{Call MyProc (Param1) }
However it does work from Query Analyzer. The syntax appears to have remained the same according to 2005 BOL.
Does anyone know if this is a known issue?
November 10, 2006 at 2:39 am
Explain "doesn't work". Does it give you an error? If so, what is it? Does it say completed successfully yet nothing was done by the procedure?
And post the code please.
Help us to help you.
November 10, 2006 at 6:21 am
Here is the error I receive when run in Management Studio:
Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '{'.
Here is my code:
{
CALL s_EmailHistory ('user@domain.com')}
This extact code works fine in QA but not the Management Studio.
November 10, 2006 at 10:54 am
Well, Call is not a T-SQL command, it is an ODBC/SQL Native Client command. So it would appear that the change is not with SQL Server itslef, but rather with the new management studio. I don't know why Management Studio doesn't support it, but the T-SQL comparable method, Execute, is supported in both.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply