Forum Discussion
Data transferring from SQL server table to text file without using bcp
Hi friends, I have data in SQL server table and I need to transfer from it to the text file with specific name format and with column names and specific data size of the data types. I couldnt do ...
Sreej320 if you don't want/can use BCP then use SqlCmd; but that don't change anything on the required permissions. See
olafhelper thanks for the help. Do we have any method to transfer columns names of the table to text file as well. When I use BCP I'm getting only data not the table column headers. Pls help if u know any solution
Sreej320 , See the link for SqlCmd I posted => parameter -h headers