120 pts.
 Ability to spawn (or fork) a sproc in SQL Server 2000
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.

Software/Hardware used:
ASKED: June 27, 2008  5:32 PM
UPDATED: June 30, 2008  4:51 PM

Answer Wiki:
Check out the answer to this similar question, titled <a href="http://itknowledgeexchange.techtarget.com/itanswers/spawning-additional-stored-procedures-in-sql-server-2000/#viewanswer">Spawning additional stored procedures in SQL Server 2000</a>.
Last Wiki Answer Submitted:  June 30, 2008  4:51 pm  by  BrentSheets   6,565 pts.
All Answer Wiki Contributors:  BrentSheets   6,565 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _