<div>
Try closing and reopening EM.<br />

</div>


<div>
There is something corrupt on the server. &nbsp;We have abandoned trying to repair it. &nbsp;Thanks all for you comments and sorry it took so long to close this question
</div>


There is something corrupt on the server.  We have abandoned trying to repair it.  Thanks all for you comments and sorry it took so long to close this question

<div>
<div class="content wysiwyg-content">
I am getting an odd SQL error. <br />
<br />
If I open enterprise manager and select the table in question. &nbsp;I get the following message.<br />
*******************<br />
The Selected object has been dropped from the database. &nbsp;Select Refresh to see the current objects.<br />
*******************<br />
<br />
If I select Refresh the table is still in the list.<br />
<br />
If I &nbsp;do a SELECT * FROM tbTableInQuestion I get this message<br />
<br />
<br />
*******************<br />
Microsoft OLE DB Provider for ODBC Drivers error '80004005'<br />
<br />
[Microsoft][ODBC SQL Server Driver][SQL Server]Location:<br />
q:\SPHINX\NTDBMS\storeng\d<wbr />rs\include<wbr />\record.in<wbr />l:1447 Expression:<br />
m_SizeRec &gt;&nbsp;0 &amp;&amp;&nbsp;m_SizeRec &lt;= MAXDATAROW SPID: &nbsp; &nbsp;56 Process ID: &nbsp; &nbsp;980<br />
<br />
*******************<br />
<br />
Any thoughts on what is happening? &nbsp;I need the data in the table. &nbsp;Not sure if there is a backup somewhere. &nbsp;It's someone elses system.<br />
<br />
Thanks
</div>
</div>


I am getting an odd SQL error. 

If I open enterprise manager and select the table in question.  I get the following message.
*******************
The Selected object has been dropped from the database.  Select Refresh to see the current objects.
*******************

If I select Refresh the table is still in the list.

If I  do a SELECT * FROM tbTableInQuestion I get this message


*******************
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Location:
q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID:    56 Process ID:    980

*******************

Any thoughts on what is happening?  I need the data in the table.  Not sure if there is a backup somewhere.  It's someone elses system.

Thanks

Error with seemingly dropped table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.