Hi,

thanks again for the replies.

At the moment, the process we have for dropping these tables does indeed run out of hours.

However, I've been tasked with rewriting it for a number of reasons and although it will still run out of hours, I kinda got stuck up on trying to make it as fast / efficient as possible.

while the actual performance impact won't matter because it's out of hours, it'd make me feel good if I could improve the performance.

After reading loads of posts about the performance impact of cursors etc, i wanted to try to drop multiple tables as efficiently as possible without a cursor

Thank you all for your help