Oops, sorry Tremorden. I was looking at your level instead of your name. Cheers,

Jim

An excellent suggestion from Enthusiastic.

How are you executing the batch file? Are you double clicking it or are you opening a command window and executing it manually? I usually find that the...

Yes,

here I have told the FOR command to use forward slash instead of space as a delimiter. This stops it splitting the filename at the space (and / cannot...

If you are asking how to schedule the query then yes, a SQL Server Agent job will do the trick. If you are asking about the SQL, then check...

Try the following changes to your batch file syntax

for /F %%X in ('dir /b /ON *.sql') do SQLCMD -S ServerName -d DatabasesName -U UserName -P UserPassword -I...