Each session should be able to have its own temp table, but there can be problems.

(Kenneth Fisher) You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things that differentiates a global temp table from a local temp table. But there can be some difficulties with that.

Register to Read