Feature request: include column header names in CVS files

weswinkler

I love Multi Script, since it allows me to collect similar data from many databases at a time.

I wish it had an option to include the column headers in the CSV files. This would be similar to SQL Management Studio's ability to include headers when copying or saving results shown in the grid.

Currently, if I wish to assemble a nice Excel file with headers, I execute my query manually on a single server, and save the grid output with headers. Then I run Multi Script on all servers, and transfer the headers from the first file to the Multi Script file.

HJoyce

Thanks for this feedback. It is already logged (SE-637).

Linda Hawksworth

I hope you will be pleased to hear that we have a patch for SQL Multi Script where the CSV file had no column headers. Please download it from:

ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip

and confirm it fixes your issue.

tkdennis

That works great! Any chance we could get a "Copy with Headers" for the right-mouse menu? It currently has Copy and Select All.

Thanks,
Traci