If you are using local temp tables then SQL Server ensures each name is unique.
If you are using global temp tables then you must ensure the names are unique.
How are you planning to use the temp tables?
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems