One big issue with xp_cmdshell command to create text file

Question

One big issue with xp_cmdshell command to create text file

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

You have to use a doube >> to pipe the results to a file at the command prompt.

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

What version of SQL Server are you on currently? If you are on SQL 2005, a CLR procedure with EXTERNAL ACCESS would be a much more secure method of doing this process.

Paresh Prajapati SSCertifiable Points: 7567 More actions · Answer 3

Sorry @filecontent is not displayed, bec it contains open tag ' '

so, can u tell me, how can i write ' ' in file ?

_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 4

What do you want it to contain specifically?

J-440512 SSCertifiable Points: 6285 More actions · Answer 5

I use something like

[font="Courier New"]'type filename.txt > a.txt'[/font]

** NOT ** [font="Courier New"]'type filename.txt' > a.txt [/font] as in "greater than"