How do I create a temporary table on the server without it being in the
regular database directory?  Due to possible size issues, I don't want to
create memory tables.
I know the
 select * into \memory\temptablename from tableA
but is there a
 select * into \temp\temptablename from tableA

I want to be able to share the data in the application like a memory table.

Bill

B Miller wrote:
> How do I create a temporary table on the server without it being in
> the regular database directory?

You can't. A server db is more or less a directory.

....
> I want to be able to share the data in the application like a memory
> table.

You can use a GUID without the {} or something similar as table name. Should
do the trick, mayxbe 5 lines of code.

Ralf

I thought you could as long as you knew the full path. It might make it a bit difficult to allow others to share it since you'll need to share the unc path with all the clients. Also you'll have to make sure the temporary directory is already created.


What's wrong with it being in the database directory?

Roy Lambert

> What's wrong with it being in the database directory?

Probably nothing "wrong" with it being in the database directory.  I just
was looking to keep my db directory cleaner with temps being in a separate
directory that could be easily emptied.

Thanks,
Bill

Bill


I think that I've seen references to db\subdir\file but I'm not sure. If my memory's not playing me false you could create a directory off the main database and use that.


Roy Lambert

Bill,

<< How do I create a temporary table on the server without it being in the
regular database directory?  Due to possible size issues, I don't want to
create memory tables.
I know the
 select * into \memory\temptablename from tableA
but is there a
 select * into \temp\temptablename from tableA

I want to be able to share the data in the application like a memory table.
>>

The best option would be to create a database directory called "Temp" for
this purpose.

BTW, ElevateDB always has a "Temp" database available that corresponds to
the temporary database directory for the database server.

--
Tim Young
Elevate Software
www.elevatesoft.com