Grant Fritchey (4/19/2010)
Another option would be to use a minimally-logged operation such as bcp or BULK INSERT.
I'm confused as to how BCP or BULK INSERT would help, considering the data is already in a table.
Perhaps using SSIS would minimally log the transfer? I've avoided using it in the past because I am unsure about the UDF call.