Export using Stored Procedure

• norbertackerman

  SSC Eights!

  Points: 945

  More actions

  April 29, 2009 at 11:09 am

  #209065

  I am using SQL Server Management Studio Express. My DB is SQL 2005.

  Is there a way to a CSV file using a stored procedure?

  Thank you!

  Norbert

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  April 29, 2009 at 11:12 am

  #986144

  I use bcp with xp_cmdshell. See if this article helps...

  http://www.mssqltips.com/tip.asp?tip=1633