>>>>>Did you already check sqlcmd parameters and samples in BOL?
>>>>
>>>>No, because this is really a windows command thing rather than a SQL Server thing, I think
>>>
>>>sqlcmd allows to output information into a text file. Go ahead and read BOL.
>>
>>OK, thanks. Any idea on checking the result of the copy command?
>
>
http://www.robvanderwoude.com/battech_redirection.php>
>Also, perhaps you want to use PowerShell script? It has more power than DOS batch file.
Thanks, no, I don't want to spend any time on this, just get what they already have running.