Feature request: include column header names in CVS files

Single-click script execution on multiple SQL Servers.

Feature request: include column header names in CVS files

Postby weswinkler » Sat Jan 23, 2010 12:49 am

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.
Posts: 34
Joined: Tue Nov 11, 2008 7:12 pm

Postby HJoyce » Tue Jan 26, 2010 12:07 pm

Thanks for this feedback. It is already logged (SE-637).
Posts: 149
Joined: Mon Oct 10, 2005 8:48 am

Postby Linda Hawksworth » Tue Feb 02, 2010 12:48 pm

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.
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 10:32 am

Postby tkdennis » Thu May 27, 2010 5:51 pm

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

Posts: 75
Joined: Fri Feb 29, 2008 12:13 am

Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests