Save SELECT Query Output to Text File

• kamil ikmal

  SSC Journeyman

  Points: 93

  More actions

  December 2, 2008 at 8:45 pm

  #198429

  Hi ,

  I 'm just want to share knowledge .

  Normally we change result view by go to Query>Result To>Select Result to Text / Result to Files/Result to grid

  This link good to understand to who want get select Query Output to text file

  http://www.sqlservercurry.com/2007/12/redirect-select-query-output-to-text.html

  Thanks

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  December 3, 2008 at 11:16 am

  #907050

  It's easier to do it in BCP or SQLCMD, without opening up xp_cmdshell for security reasons

  And I find SSMS Result to Test good enough most of the time

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005