output table to .csv with MSSQL

Hello,

I'd like to finish up a stored procedure I have that updates a table with information based on our constituents. I would like it to regularly export this table to overwrite a file on my system.

Are there TSQL commands that I should look into to programmatically write this to a file?

Are there any strange Tess-related hurdles to exporting files I should know about before I get started?

 

Thanks,

Aaron Glynn