Information générale
Titre:
SQL Server temdb with large dbfs
I have a 3.5G database containing a table that is 1.5G that will grow quite large. I wish to run some queries off of it in VFP 5 and just return the results.
Although I've programmed in Fox since '84, I'm not very familiar with SQL Server (6.5).
When I try to use a remote view that I created, I get an ODBC error that says my temdb is full (I increased it to 7 MG). If I am not filtering in my remote view, I think I would need to have a tempdb of the equivalent size of the largest table in my database. Is this a correct assumption?
Is there a way around this?
Eventually I will be linking up FoxFire! to this and coding it such. But I would like to just send the query across and receive only the selected records. If I use VFP's GUI SQL creator, I need to load a table or view. If I load the view (containing all the records), I need a HUGE tempdb....help!
there's gotta be an easy way out of this....
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement