thanks, I'll use your if exists statement in my stored procedure.

I'm still a little confused about how the temp table stuck around, there shouldn't be any open connections related to...

Is there a way to tell which connection it was created under? It was either A) either created by a scheduled job which also should have dropped it or...