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.
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.