davidevery
10-08-2003, 01:16 AM
I am running an SQL Server command to drop and restore a database using the OSQL capability of Visual Build.
Sometimes this step fails becuase some SQL processes may be preventing the drop, and I need to loop and retry it a few times until it succeeds.
How can I retrieve the standard output of the step when it fails (or succeeds) so that the script knows whether to continue trying or exit the loop ?
Sometimes this step fails becuase some SQL processes may be preventing the drop, and I need to loop and retry it a few times until it succeeds.
How can I retrieve the standard output of the step when it fails (or succeeds) so that the script knows whether to continue trying or exit the loop ?