>
>The ## prefixed tables stay for the duration of your handle; the # prefixed stay for the duration of your current batch, which is a tad harder to define - generally, when you need them again, you need to create them again; when your batch failed and you run it again, they are still there and you have to drop them first.
>
< snip >
Global (##) tables are visible to to any user and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
--sb--