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"