>when I export from SSMS a result subset of data to a CSV (using Save As) all the datetime fields result in '00:00.000' . Is there a trick in getting SQL to output these correctly ('2012-06-05T12:32:45').
>
>Never mind, I figured it out.

These are always the easiest ones to figure out ;-)