Now that I have tried to use a UDF that returns a table variable, I hit this wall:

"Only functions and extended stored procedures can be executed from within a function."

Inside...

Thanks for the replies. I knew that a UDF would be an option, BUT in a programming sense, a function should perform 1 purpose. What the stored procedure would be...

The only problem with this strategy is that you are relying on the backup to tape actually working before you copy the files to another server then delete the originals....