I've seen mixed answers on this even here on stack and hoping to find a definitive answer. Are multiple parallel calls to the same stored procedure that internally creates local temp tables using inbound parameters going to collide with one another? Basically are local temporary tables or any flavor of temporary tables thread safe.

Thank you!

Tim