SET Pause questions

Hi all.

I have a strange problem that I cannot seem to figure out.

I have a DOS batch file that calls a sql file that lists quite a few sql files in order. Essentially, what I want is a pause and prompt between each execution.

I have something like

set pause on
prompt 'doing step one'
_at_c:\folder\file1.sql

set pause on
prompt 'doing step two'
_at_c:\folder\file2.sql

set pause on
prompt 'doing step yada yada'
_at_c:\folder\file3.sql

The first prompt and pause is woking - but then it just cruises through the rest without stopping. In bed last night I thought about putting the set pause on in each of the individual files and not the main sql file that runs them.

Any thoughts?

-sn Received on Fri May 17 2002 - 14:47:07 CEST