it works for me on SQL Server 2000. I'm getting a list of all the temporary tables.

-Mike

>'sp_tables' used to give us the # tables in the tempdb/user tables area, but not anymore with Sql 2000. The line that worked in Sql 7:
>
>use tempdb;exec sp_tables '#Calc%', @table_type="'TABLE'";use mc_main_exl
>
>This is breaking our cleanup routine so that a second run crashes into the # tables already created. Any ideas? Thanks.
>
>We enabled DataReader in tempdb and now we can all the # tables, even those not from our current connection. Woah. We can't be whacking other folk's temp tables. Help!