Nevermind, I've found I can use the TABLE variable type in my sp so the table is only created locally to the sp (btw, this is new to SQL2K).
Any advice/experience on the performance of this would still be appreciated, Alex > > I'm writing a stored procedure (in SQL Server 2K) in which I > need to create > a couple of temporary tables (which are dropped when the sp > has completed). > > How do I get around the fact that 2 users of the website may > run the sp at > (precisely) the same time, creating the possibility that one > of the sp's > drops the temp table before the other has finished with it. > > The SQL documentation refers to the fact that each > 'connection' will create > it's own copy of the temp table - avoiding the problem above, > but when the > db is connected to the website, I only have the one > connection between CF > and SQL, so the problem may occur - or will it? > > Does anyone have any advice/best practice for this situation? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm