Private Directory

[Pete]

I've experience with Paradox were you can create temporary
tables in the user's private directory. I've created
stored procedures to create tables using
CREATE TABLE #tblMyTable... How can I access these
tables, or even view them? What is the proper syntax for
stored procedures?

 

[Uwe Ricken]

Hi Pete,

SQL-Server is working with temporary objects (PREFIX: # or ##)
in the tempdb which is a database on the sql-server.

This tempdb will be recreated every time the server has been
rebootet.

To access these TEMP-Tables use:

e.g.: SELECT TEMPDB..#myTempTable

HTH ;-)

--
Gruß, Uwe Ricken
MCP for SQL Server 2000 Database Implementation

GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm

 

[Pete]

Why isn't it working for me?