Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it's output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!