• Yeah, I assumed SQL2008 might have been ok for this. I ran it on SQL2005 and got the error.

    The Rollback Transaction statement seems to drop the temp table.