Hi Alan

Take a look in the TempDB database in the User Tables section. You should find your temporary tables in there. This is one of the purposes of the TempDB database.

HTH


>In the T-SQL window I have created some temporary tables using the syntax
>
>SELECT * INTO #MyTempTable FROM MyTable.
>
>Where can I find what temporary tables are currently available (I don't want to delete them yet using DROP TABLE ...)? I cannot find them in any enterprise mgr. table listing. Is it stored in memory like a VFP temporary cursor? What is the scope of these 'tables'? Are they present until the SQL session finishes?
>
>Any help would be appreciated.
>
>Alan