Destroying a #tempTable

Results 1 to 3 of 3

Thread: Destroying a #tempTable

  1. #1
    mmaz Guest

    Default Destroying a #tempTable

    Is it necessary to drop a make-table query? If so, what is the syntax?<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Destroying a #tempTable

    The table will be dropped automatically by the database when the users session is over, but that doesn&#039;t always work as well as it&#039;s supposed to and uses up a lot of resources.<BR>The syntax to drop the table is:<BR><BR>DROP TABLE #TempTable

  3. #3
    mmaz Guest

    Default RE: Destroying a #tempTable

    I tried that, and I got the following error:<BR>Microsoft OLE DB Provider for SQL Server (0x80040E37)<BR>Cannot drop the table &#039;#Temp1&#039;, because it does not exist in the system catalog.<BR><BR>What is causing that? Do you know of a fix?<BR><BR>Thanks for the help!<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts