Toreador (3/9/2012)
sqlmunkee (3/9/2012)
Even if you hadn't added the constraint to the table, the second program would still fail because there would already be the temp table from the first program.That's not true. You can create as many identically named temp tables as you want provided they are in different sessions (even 2 different connections for the same user).
yes, the temp table with same name can definitely existed in different sessions.