did you grant permissions (read/write/list) to everyone to the temp folder of the user that the instance is running under? - this as per my second link above.

For network accounts,...

Definitely there isn't even a need for db_owner for developers.

Based mainly on the work from Solomon I have implemented a solution in one of our servers (to be expanded to...

• This reply was modified 6 years, 3 months ago by frederico_fonseca.

some people have difficulty understanding what they are being asked to do so lets see if a explanation with images help.

follow the instructions on this link to see if you...

yeah..

its doing more than that - it just happens that today (Sunday) happens to be a week boundary.

try it with multiple dates (consecutives, spawning 2 -3 weeks) instead of getdate...

"0" (zero) on these cases means the default value for datetime - which you can determine by a simple change to that code (or by reading the manuals)

are you sure? did you run it? and does it really look like the number of weeks that 20 years would have?

looks clear enough for some one with your level of experience.

so what seems to be your question after you have run "select DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0)" to see its result?

there is a way - I'll need to dig trough my c# code to find it.

basically a c# that loads the package, loops through the scripts and recreates them using...

I've used  Sparxs EA Both as individual and within the corporation . Price isn't that bad

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same...

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same indexes.

As for...

note that as long as you have Enterprise version you can use the Attunity driver - does not need to be the 2019 version, and as they say on the...

DefaultBufferMaxRows = 2000 -- change to 50000

DefaultBufferSize = 1048576 -- change to 10485760 ( x 10 basically)

tablock = set to true so it can use minimal logging

connection string - set...

are you sure that tbl_name  is really a table and not a view?

that SQL so simple would give that error if it was from a view with invalid data on...