I am trying to achieve the same thing as you. I need to archive data from a Production database into an archive Database. The db still needs to be online....
Great Post. This will definately help me. I tried manipulating your code to work for me and i get an "Msg 207, Level 16, State 1, Line 27 Invalid column...