>What happens when you run the store procedure from the "Enterprise Manager"?
>Terry,
My stored proc :

Create procedure test as
raiserror('Test message',16,12)

I only can run from Query Analyzer,
EXEC test

and the result is :

Server: Msg 50000, Level 16, State 12, Procedure test, Line 2
'Test message'

From VFP :
nRet=sqlexec(nConn,"{call test}")

when executive , nRet=-1 and have no run-time error. Aerror() return 0 for 1st item.


>
>>Hello all,
>>
>>How to trap SQL Server error.
>>My SQL Server stored procedure raise error, but command :
>>sqlexec(nConnHandle,stringCallStoredProc) only return -1.
>>How can i get error from SQL Server ?
>>
>>Thank in advance.