It works, thank you very much Steve!

Hi All,

please,

How do I make SQLCMD retrieve any SQL file name using –i? (* .sql) If there will always be only 1 file *.sql in the directory?

Thx!

M2F

Hi,

FOR /F "tokens=1 delims=," %%G IN (instanceslist.csv) DO FOR /F "tokens=1 delims=," %%G IN (instanceslist.csv) DO SQLCMD -S %%G -i "acl.sql" -m 12 -E -o "protocol_output.txt"

If I have 5 database...

• This reply was modified 5 years, 1 month ago by  Mark2Fox.

FOR /F "tokens=1 delims=," %%G IN (dblist.csv) DO FOR /F "tokens=1 delims=," %%G IN (dblist.csv) DO SQLCMD -S %%G -i "acl.sql" -m 12 -E -o "protocol_output.txt"

How do I make a...

Unfortunately the policy of the organization banned Powershell.      That's what I suggested first.

Your solution looks effective.

Thank you.