Viewing 6 posts - 106 through 112 (of 112 total)
Paul White (11/8/2009)
dant12 (11/8/2009)
if you're using SQL 2008 you can disable lock escalation on the problematic tables and enforce rowlocking on the table, that should solve the concurrency problem
Not necessarily....
November 8, 2009 at 1:57 pm
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...
November 8, 2009 at 8:35 am
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...
November 8, 2009 at 3:52 am
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?
July 2, 2009 at 1:24 pm
ah, yes.
pasted it in notepad and got to see it
quick replace fixed it
July 2, 2009 at 1:18 pm
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?
July 2, 2009 at 12:37 pm
Viewing 6 posts - 106 through 112 (of 112 total)