I'm not sure how to make this work. For an alternate, before creating the table, check to see if it exists:
IF object_id('tempdb..#con1') IS NOT NULL
DROP TABLE #con1
-Mike
>We can too now that we've enable DataReader, but we can see # tables from other connections as well, which we don't want. We need isolation per connection.
>
>ACCESSIBLE_TABLES is Y in the result set for sp_server_info.
>
>Any ideas? Thanks.