We had the same problem, worked in test and not Production. We fixed the issue but does anyone know what the root cause is?

So we can change our test to match prod. We have checked all versions of SQL, drivers and operating system. We use SQL 2008 R2, enterprise

thanks