Great question.
But am I the only that thought that the syntax error was part of the question?
But even so there wouldn't be a right answer for that.
I didn't understand the explanations about the conflict in object names.
Doesn't that only happen with global temp tables (those starting with ##)?
EDIT: Nevermind. I read the error messages wrong.
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA