• I see what you are getting at but the situation is that I am installing databases on someone elses i.e. customers servers so this would be a bit "chicken and egg". It's great for my test environment thought.

    Ideally I would like to be able to do something along the lines of

    echo off

    cls

    osql -USA -PPassword -iInstall01.sql -oInstall01.Err

    if ErrorLevel==0

      osql -USA -PPassword -iInstall01.sql -oInstall01.Err

    etc

    In an ideal world I would like something like the install routine that is used to apply SQL Server service packs. The one that says "applying n of m".