SQL Server Performance

How to Call a SP from another SP..

Discussion in 'General Developer Questions' started by Sandy, Mar 1, 2009.

  1. Sandy New Member

    Hi All,
    I wants to call My Stored procedure from main stored procedure.
    Its working fine.. but how can I know if any error happen in the execution time..
    Thanks,
    Sandy.
  2. FrankKalis Moderator

    One way could be to use return codes, provided you are still on SQL Server 2000. Check out http://www.sommarskog.se for two great articles about error handling.
  3. Sandy New Member

    Thank You.I will check this....[:)]
    Thanks,
    Sandy.

Share This Page