I am sorry everyone but I have moved to France working in a NGO so I have very little time these days to work on \ look at SQL -...

Oh great - even in future, I got the question wrong - great motivation!!! 😀

Ideally, you should run these type of jobs when database is in maintenance window - if possible, try to schedule it when the application is not using the DB. If...

I would like to see how this can be implemented in SQL 2008 - would you recommend using same method you shared or using the newly release feature of change...

To be honest, I have not tried as I don't have access to one - if you can test it on dev or test environment, it would help.

It seems the script that got published has space unicode characters in it - I am attaching a zip file with compiled query - let me know if that works...