Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-23 : 09:47:54
|
| Roger writes "We have been processing data using SQL2000 in VB by creating and updating temp tables. Then select * from temp table into a recordset and drop the temp table. The recordset is then processed. Our problem is occuring after switching to SQL2005. We seem to be loosing our recordset as soon as the temp table is dropped. Is there a setting that can be changed to allow the recordset to be kept after the drop of the temp table it was created from, or do we have to change all of our code to drop the temp table after we are done with the recordset?Thanks,Roger" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-23 : 11:47:50
|
| Are you using disconnected recordset? If not, give it a try !Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-23 : 12:01:14
|
| How are you doing this - in a stored procedure?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Loosing a recordset after dropping the temp table in SQL2005