Question: how to export table data in sql server 2008?
Answer: Right Click over the Database name -> Tasks -> ExportData., Choose the table as Data Source., Choose Flat file destination as destination., Choose a FileName., Mark "Column Names in the first data row"