[dba-SQLServer] Error Trapping and temp tables

You should create temp tables in a temp mdb. Saves on bloat among other 
things.
See Tony Toews method

http://www.granite.ab.ca/access/temptables.htm

Mark L. Breen wrote:

>Hello All,
>
>I am developing a db and intend to use a temp table. Before use I create it and after use I drop it.
>
>However, because I fear it may somehow remain in the system, I would prefer to do a 
>
>If exists (table name) drop table name
>
>But it is not that easy with temp tables, as you know, so I was considering using a vb function that attempts to drop the table, I can catch the error in vb, I hope, and ignore it.
>
>Have you guys any better suggestions how to do this.
>
>Basically, I want to check for the existence of a temp table and drop it if it exists.
>
>Thanks in advance,
>
>Mark
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada