Wayne,

SQL Server supports two types of temporary tables: local (#) and global (##). A local temporary table (#table) is scoped to the connection that created it. A global temporary table (##table) is visible to all connections but it will be released when the connection that created it is closed.

Also be careful with temporary tables and stored procedures. If a stored procedure creates a temporary table, the table will be released when the stored procedure terminates.

-Mike