Use xp_cmdshell and bcp utility not working

Question

Running these on SQL server 2014 SP3

EXEC master..xp_cmdshell 'dir c:\' -- This is working

** The following is on a single row **

EXEC master..xp_cmdshell 'bcp "select name, type_desc, create_date from sys.objects" queryout "c:\bcptest2.txt" -T -Sbl3c0b\switch2014 -c -t,' --This is not working

I ran the bcp from the command prompt successfully but from using xp_cmdshell it is not working at all.

I ran the following already

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Thanks!

Never mind. From home on VPN it was not working but when I got to work space, it worked. — user1706965, Feb 26 '20 at 15:44
Did you really not include the -S option? Or did you leave it off your post intentionally? — jamie, Feb 26 '20 at 16:14

score 0 · Answer 1 · answered Feb 26 '20 at 15:46

0

From home on VPN it was not working but when I got to my company work space network, it worked.

I don't know why but at least it is working as expected.

answered Feb 26 '20 at 15:46

user1706965

1
1

Use xp_cmdshell and bcp utility not working

1 Answers1