Feature request: include column header names in CVS files

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Feature request: include column header names in CVS files

Postby weswinkler » Sat Jan 23, 2010 1: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.
weswinkler
 
Posts: 32
Joined: Tue Nov 11, 2008 8:12 pm

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

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

Postby Linda Hawksworth » Tue Feb 02, 2010 1: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 11:32 am

Postby tkdennis » Thu May 27, 2010 6: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.

Thanks,
Traci
tkdennis
 
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest