I've been running something similar but with a run-once flag file for safety.

Darragh

ECHO OFF

IF EXIST _FLAG.TMP GOTO ALREADYRUNLABEL

GOTO OKTORUNLABEL

:ALREADYRUNLABEL

ECHO This SQL update batch file has already been run once.

ECHO Please...

For us its weekends only for a major upgrade (once a quarter).

If its a small patch fix we can go on a weekday, but in the early morning (European) time.

D.