I got a request to Export SQL Server 2005 tables to text file in the below format. Please let me know the steps to perform.
1. Pipe delimited text files with column names in the first row
2. Text values qualified by Double Quote
3. File names denoted with a “txt” extension.
Thanks in advance