How to Return Column Headings When Run exec sp_configure

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  August 7, 2008 at 5:29 pm

  #192157

  hi experts,

  It has been a common problem/reuquest from SQL Server people - to

  be able to return column names when you select against a table or view.

  I need to run sp_configure and several other system SPs against several databases then paste the results into an Excel worksheet.

  Anyone have a magic solution ?

  Thanks, John

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 7, 2008 at 6:14 pm

  #854841

  To change the current query window:

  Right-click in your SSMS Query window, select "Query Options..."

  Select "Results..Grid". Then check "Include Column Headers...".

  Use "Tools..Options.." from the main menu to change the defaults for all new query windows.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  August 7, 2008 at 7:07 pm

  #854854

  Thanks rbarryyoung. The best and easiest solution I've had yet.

  I'll post back tomorrow.

  John

• dbaforever

  Hall of Fame

  Points: 3740

  More actions

  August 8, 2008 at 12:59 pm

  #855485

  This worked perfectly, rbarryyoung.

  Just what I needed. Thanks

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 8, 2008 at 1:19 pm

  #855497

  Thanks for the feedback, John.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]