thank you this is a great code, only one question, why does it keep saying i have open transactions when i run dbcc opentran it keeps saying i don't.