|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
September 15th, 2004, 12:47 AM
|
|||
|
|||
TempDB Issue
My ASP.NET application requires me to create various temporary tables in TEMPDB. There is a problem that I am facing for which I need a solution badly.
There is a class which creates a temporary table in TEMPDB. There is another class which needs to use this temporary table. The issue is once the first class is exited or the connection to the database is closed, the temporary table vanishes and there is a runtime error thrown by the second class as it cannot find the temporary table. Is there any way I can persist the tables in TEMPDB for subsequent operations? Any help or clue in this regard would be a major help
|
|
#2
September 15th, 2004, 04:18 PM
|
|||
|
|||
|
If you could persist them, they wouldn't be temporary.
Do you _have_ to use tempdb? Is this some ASP.NET idiosyncracy or can you use a different design?
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > TempDB Issue |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
