Local And Global Temporary Tables In SQL Server

Some good information for those wishing to create temp tables in their stored procs...

It seems that CREATE TABLE #tablename is very local, however ## is not so local after all...

• http://techahead.wordpress.com/2007/09/27/sql-temporary-tables/
• http://stackoverflow.com/questions/126012/view-temporary-table-created-from-stored-procedure