sqlserverexport
Step-By-Step Instructions on How to export query result to .csv file in SQL Server 2008

1. Open SQL Server Management Studio

2. Go to Tools > Options > Query Results > Results To Text

3. On the far right, there is a drop down box called Output Format

4. Choose Comma Delimited and click OK