Andre 425568 (8/12/2014)
I will so what the settings are in SSMS and SSIS, but I do not think that is the issue, the normal queries, that also run from a gile location, example that set up primary and foreign keys, create indexes etc are all running within what we are expecting.
Yes, but DDL operations don't (usually) return result sets and so network latency is much less likely to be a factor. Also, DML is more likely to be sensitive to options and regional settings. Would you be able to post a snippet of your code (or all of it), please?
John