How to retrieve StoredProc raiserror code?



I have a stored procedure that is failing and issues a raiserror. How to
determine that in my win32 app? And get the return code?


.



Relevant Pages

  • Re: "Must declare the scalar variable @Nickname"...
    ... what's failing is the stored procedure: ... count or debug the sproc. ... Regards. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Output Parameters set by Stored procedure
    ... The problem is that I was using Raiserror and then ... issue an raiserror so the DTS takes a different branch. ... > Global Variables and Stored Procedure Parameters ...
    (microsoft.public.sqlserver.dts)
  • Re: RaiseError with @@ERROR as first parameter
    ... Why would you want to raise an error ... Also, even if RAISERROR ... SQL Server MVP ... > I can not change the stored procedure code.. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to handle stored procedure in VBScript
    ... this stored procedure was not created by ... > First, if you want to return a parameter, you need to declare it as ... And last, why you call RAISERROR? ...
    (microsoft.public.vb.database)
  • Re: procedure with temp tables
    ... NOCOUNT ON at the begining of your stored procedure? ... > DTS activex script, it is failing. ... > procedure i am able to execute in the same activex script, ...
    (microsoft.public.sqlserver.dts)