Hi all, 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? thanks, Alex ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
