Exec storedprocedure results don't have header info?

It takes additional steps to include column headers with bcp export:

http://stackoverflow.com/questions/1355876/export-table-to-file-with-column-headers-column-names-using-the-bcp-utility-an

http://stackoverflow.com/questions/13832150/get-the-column-names-of-a-stored-procedure-when-using-bcp-queryout

Consider SSIS Import/Export Wizard, just a checkmark to include the header:

http://www.sqlusa.com/bestpractices/ssis-wizard/

SSIS package can be saved and reused ( a bit more complex than bcp in this regard).

---

Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012