Date: 09/24/07 (SQL Server)    Keywords: database

I'm a tad confused here. I thought when you used the syntax...

CREATE TABLE ##m_tblOpenReceipts(

...that the table was destroyed when the stored procedure ended. So why, when I try to run it a second, time, do I get the error...

Msg 2714, Level 16, State 6, Line 43
There is already an object named '##m_tblOpenReceipts' in the database.

...?

(This is also the case with a single pound.)

If I'm wrong about this, as I seem to be, how does one create a true temp table?

Source: http://community.livejournal.com/sqlserver/63487.html