you can easily update the code I supplied to flag when a circular happened - I would be pretty sure that that is what is happening to you

potentially outputting the...

Normally when I am working with rCTE I add a column to prevent circular dependencies (which is what normally causes the max recursion error)

example below is to do with Active...

I think it...

According to licensing terms Developer only on a...

same as I gave original - do the data migration yourself without using SSMA

none of those are replacements for RDCMAN - those are just Remote Desktop options

just one list - will not recommend any as you will be the one that needs to...

did you even bothered googling for it?  replacement for RDCMan shows lots of hits

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, 4 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?