NJ-DBA (10/17/2011)
you could create a OS command job stem andcall sqlcmd from the OS with the header option set like so:sqlcmd -h-1 -i "D:\scriptdir\script.sql" -o "D:\outputdir\outputtext.out"
fairly sure that'll give you what you're looking for.
just noticed the age of this thread... saw the previous BT ? post... anyhow better late than never?