I have another challenge.

Every month, I get about 15-20 scripts to be run against a database in Test Environment.

The scripts are numbered sqlscript1-15 or 30.

I somehow cannot get SQLCMD to work for it.

Has anybody, had success doing that.

If this works, I need to run the same scripts against Production.

Saving of output is also desired.

I can of course create a batch file with all scripts names hard coded, but then....there is no challenge.

Any help is welcome.

Paresh Motiwala

Boston