temporary table problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom (Tom_at_discussions.microsoft.com)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 07:07:20 -0700

I am building an internet appliacation. Many users share only one sql login.
During page generation there is on stored procedure, which creates temporary
table #tmp_table.

Can I have problem with this approach? It seems to me, that yes. If for
example two users need the same page, so two #tmp_table tables must be
created. Is it possible? I think that no, becouse of sharing of one sql login
ana thus the same sql namespace.

Thank you Tom