Belts and braces, can you please check that you have the servername correct? I have just tried it with my localhost\sqlexpress and it works OK. Here is the command that...

Hi,

I am using V2 of PowerShell...

============================================================================

C:\Users\7319>powershell.exe

Windows PowerShell

Copyright (C) 2009 Microsoft Corporation. All rights reserved.

PS C:\Users\7319> $Host

Name : ConsoleHost

Version...

Awesome thanks Mike!!

Problem resolved by using smaller BCP files. So instead of having 1 file with 2.7 million records, instead have 3 with an even distribution.

Thanks for your help everyone.

Neil

Hi Muthukkumaran,

I think that you have hit the nail on the head. We created an empty database on the SQL Server Express dB, and then attempted to pre load the...

That's the one.

Many thanks!!