Questions tagged [bcp]

The tag has no usage guidance.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
2k views

BCP/xp_cmdshell access denied - but only when running procedure from outside the server

I've been attempting to run some of my team's database deployment code to a SQL 2014 server on a Windows 7 test box. Part of this code is a procedure that pulls in data from a file using BCP from a ...
Meric Stanley's user avatar
1 vote
1 answer
980 views

How do I configure a stored procedure wrapper and security settings to provide safe access to command-line operations?

I'm ultimately trying to find a way to allow the safe use of BCP and selected other command-line functionality from within SQL Server. The organisation I am in currently have xp_cmdshell disabled ...
samaspin's user avatar
  • 111
0 votes
1 answer
1k views

exporting with from MSSQL with BCP over Samba shared folder

I have a daily routine that runs over a SQL db and exports some data with BCP. I need to move these files to a Linux machine, so I shared the folder using Samba. The local export works fine, yet when ...
Mike's user avatar
  • 113