'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!