Hi

Thanks for the reply. I don't think that this is a bcp issue particularly - more why the differences when run as admin against when run as domain account. The domain...

P.S I tried running a single bcp as both Administrator and the domain account - they completed in a similar time.

So, it appears to be some resource/parallel running issue??

Are they individual "insert into" commands? If so, consider using a stored procedure instead. This saves on compilation time for each insert. We gained considerable performance improvements inserting 20 million rows...

Hi

Thanks for the reply. I read BOL a little more carefully and realised that -N is quite different to -n. -n is what I should have used. Fortunately, I have...

Hi

In another environment, I bcp'd out using -n (rather than -N) and the bulk insert back in worked fine.

Would still like to know how to get the data back in...

I'm not taking the credit for this because somebody else on this site pointed me in this direction, but this is what I use:

-- Create a temporary table to hold...

Interesting. If you're using bcp to import and you get a constraint error, bcp doesn't report an error!!

Is the data you are loading sorted by the clustered index already? If so, use the ORDER argument.

If not, is it possible to drop the indexes before loading, then rebuild...

Thanks very much for this. I'll get back to the developer to see how they want to procede. The vbscript will be very usefull if they want to go down...

mharr

Thanks for your reply. Would you be prepared to let me have a sample piece of vbscript?

Andy

I think it depends on the number of processors you have. I understand that SQL is not very good at working out how best to parallelise up when there are lots of...

Thanks Thomas, I couldn't find syjobexecute, but I succesfully used:

linkedserver.Master.dbo.sp_ExecuteSQL N'EXEC msdb.dbo.sp_start_job @job_name = "Test Job"'

Andy

Is this something to do with the eventlog tidying itself (deleting old event etc) at the same time as sql agent is tring to write to it?

We see these errors...

Hi.

Not sure that this is what I was after (although there's some useful stuff here). What I was looking for was an equivalent to @@ERROR for dbcc commands

In TSQL, you...

Hi

Taskpad view sometimes tells lies, especially if you are rebuilding indexes. You may need to run:

use <yourdb>

go

sp_spaceused @updateusage = 'TRUE'