Table schema changes sometimes
<p>We use SQL Server and ADO in Delphi and we are creating temporary tables for use with a report program. </p>

<p>The program flow is like this :</p>

<ol>
<li>Create a table with a SQL query "create table" </li>
<li>Write data in table. </li>
<li>Drop table via SQL query. </li>
</ol>

<p>It usually works, but some customers regularly complain that "drop table" fails with error "invalid object name". </p>

<p>I could get remote access to the customers database, and I saw following :</p>

<ul>
<li>the table X is shown in the table listing (by Delphi) </li>
<li>in Delphi, the table cannot be opened or deleted. </li>
<li>the table schema is "Server\1" instead of "dbo"! </li>
</ul>

<p>How could the table schema of this table change, and how should I handle this issue? Why does it work sometimes, and sometimes not? </p>