We currently use a stored procedure to do this, it was written by a DBA here. Not a whole lot of code, runs nightly and has never been a problem....