>We are already using VFP's DBC Stored Procedure, the trouble thing is sometimes (not all the time), upon terminating the apps using CLEAR EVENTS where: at Cleanup.prg we issued CLOSE ALL, and then an error box appears with message 'Store Procedure is executing'.
>
>Any Idea on this matter?

Try:

Clear All && Clean all Variable and File Pointer(All Tables will close)
Close All && Actually closing Database only
Release All Extended && Clean all Global Define Variable

In your case, you may try to release the Store Procedure VAriable by:
Clear Memory && NOT your memory... Kidding