getting standard output from OSQL

davidevery · #1 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 ?

kinook · #2 10-08-2003, 10:08 AM

The previous step's output is available in the LASTSTEP_OUTPUT system macro.