The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
73 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
174 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 ...
1
vote
2answers
439 views

What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?

As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create ...
2
votes
1answer
639 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
288 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
2answers
3k views

Minimum install of SQL Server 2008 required to able to run bcp

I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' ...
1
vote
2answers
387 views

DR - Server 2003 Std SP2 Restore AD to different hardware

What I'm trying to accomplish might be the best way to start this. I have to do a DR test. I'm given 2 days to rebuild AD, Fileserver and SQL from scratch from Dell/IBM hardware to HP Server DL380 ...
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 ...