Hi there, hope in your help.
I need to save in my hard disk the txt file generated with this code, can you help me?
The error is:
“The configuration option ‘xp_cmdshell’ does not exist, or it may be an advanced option.”
EXEC sp_configure 'xp_cmdshell';
EXEC xp_cmdshell 'bcp "SELECT
" queryout "c:\temp\test.txt" -T -c -t,';