1
vote
1answer
65 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 ...
1
vote
1answer
171 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 ...
2
votes
1answer
637 views

How do I install ONLY the bcp program for SQL Server

Just like the title says. All I need is the BCP program on my client computer. The BCP will be from a remote machine, so I don't want to install SQL Express or the management studio or any of that. ...
0
votes
1answer
286 views

SQL Server BCP performance: over the wire, or copy to intranet first

We need to use the BCP utility to port database (>1GB) to a remote database server across the internet. We can use the BCP utility to connect to the remote SQL Server, or we can copy over the BCP ...
0
votes
1answer
2k views

bcp import file how to ignore duplicates?

I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this: bcp Database..TableName in TableName.csv -n -T -E -S localhost My problem: the table ...
1
vote
3answers
2k views

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication ...