SEARCH RESULTS

I have a standard build for our environment with a default set of maintenance plans built in to the standard build. What I do is bcp out all the tables relating to maint. plans from my source server...

BCP Basics - an Introduction In this article, I’m going to walk through the basics of BCP (bulk copy program). BCP is a utility that installs with SQL Server and can assist with large ...

Script to BCP out all your tables By Vadivel Mohanakrishnan Bulk Copy Programs are really useful for Importing and Exporting data from SQL Server. There are many ways to execute BCP scripts. ...

Please try following: (A) Fully qualify the bcp executable's path (if you have MKSToolkit, run 'which bcp' to see the path of bcp executable). As in, 'C:\Program Files\Microsoft SQL Server\80\Too...

Bingo! Not that the file wasn't correct but BCP couldn't find it. It wasn't the data file at all. This has to be a difference between the two servers. The full path of the format file, as ...

New behavior. If I leave off the log file, BCP prompts me for format information (which I just default) and does produce the output file! Simply trying to BCP IN the resulting file results in ...

Same not true with my original file though. If I leave off the log file, BCP just outputs the error to the screen. ------------------------------------------------------------------ Sandra Vigi...

Here's an interesting one.... I have a 600Gb database with log shipping to a BCP server. We are planning to run a BCP test so that means after the test I will need to sync up again. The...

It could be a wrong format file. Make sure the format file is correct. Try on a test table with 2 columns or so.. - Goutam ________________________________ From: bounce-sql2k-9077134@ls....

Brett I think that if you can use BCP, then you should also be able to use DTS with the DTSrun utility. Can you pleas explain why you can move the files with BCP but not with DTSrun utility? A...

Change this c:bcperror.log to c:\bcperror.log. Do you get an errorlog file now? Will DTS import the file without errors? If DTS fails it might give a more descriptive error. Will BCP import an...

What if you leave off the log file? Cindy Gross, MCDBA, MCSE http://cindygross.tripod.com This posting is provided 'AS IS' with no warranties, and confers no rights. Please post questions...

Okay, this was bugging me and I had to keep plugging away at it and I finally got it to work with a format file to load the first two column values in the file (date and time) into a single datetime...

Weird. This just sort of hangs. The BCP doesn't seem to complete, although it does create both files. I used the sa login/password to do this. BCP pubs..authors out \\manganese\...

You will need to take a copy of master before and replace it afterwards. The standby status is in there. This is a hack. I would test it with a small db first. Jason Massie Web: http://statistics...

I don't see any issue with your steps. For Step3, instead making the copy of .mdf and .ldf files, if you have the space just rename them and when you restore with recovery files will be created. ...

Ray your exactly correct that DTS works better. The reason I am not using DTS is these files are located on my web servers which I can not get to from in side my network. So I can use BCP on the...

Okay, I think I see the problem. You have dashes in your column names, which requires the quoted identifiers be turned on. If you were running BULK INSERT inside QA, it was probably on by default. W...

You can always do a bcp -v to find its version. Also, you could check path to see which SQL Server binn comes the first. Linchi > -----Original Message----- > From: Kenneth Wilhelmsson ...

Alright! Why don't you try a different file from the same location? Say, BCP out the pubs..authors table to file in that same folder, and then try to BCP in from that file under the exact same condi...