Paul White (11/8/2009)

Not necessarily....

if your using SQL 2008 you can disable lock escalation on the problematic tables and enforce rowlocking on the table, that should solve the concurrency problem

if your using 2005 you...

im not responsible for the app that does the importing, all i know is that it calls bcp but im not sure on the parameters passed and how it imports...

according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs

u sure u did the math right?

ah, yes.

pasted it in notepad and got to see it

quick replace fixed it

For some reason I'm getting loads of "Incorrect syntax" errors while trying to compile this

edit:

what version of SQL were you using to write this?