I had a similar problem and resolved it by moving the 'set datefirst' statement to the beginning of the script.  Not sure why this worked.