• If you can run your script from SMSS, try this:

    Tools\Options\Query Results\SQL Server\Results to Text ... then choose your options.

    At least that's what it is in 2008. I can't remember if that's it exactly in 2005, but it's similar. Then select output to text when you run your script in SMSS.

    Also you can use BCP to execute a query, and BCP options can control the output format.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills