Using bcp utility to export SQL queries to a text file
bcp out
exports tables.
To export a query use queryout
instead - you'll need to wrap your query in "double quotes"
set @logtext = '"select name, type from master.dbo.spt_values where number=6"' --set @logtext = 'master.dbo.spt_values' SET @cmd = 'bcp ' + @logtext + ' queryout "c:\spt_values.dat" -U uId -P uPass -c' EXEC master..XP_CMDSHELL @cmd