<div>
Some one must have deleted the index - Manually/Via Job/Script. I dont think index just disappears.<br />
<br />
Try this and see if exists<br />
<br />

<pre><code id="code-20-41869774-1">SELECT * 
FROM sys.indexes 
WHERE name='IDX_WMSORDERTRANS_HTSYSTEM' AND object_id = OBJECT_ID('WMSORDERTRANS')</code></pre>
<br />
Are you the DB Owner ?
</div>


Some one must have deleted the index - Manually/Via Job/Script. I dont think index just disappears.

Try this and see if exists



SELECT * 
FROM sys.indexes 
WHERE name='IDX_WMSORDERTRANS_HTSYSTEM' AND object_id = OBJECT_ID('WMSORDERTRANS')


Are you the DB Owner ?

<div>
Yes see i told you!! Some one must have deleted the index<br />
<br />
Great Enjoy!<br />
<br />
Bye<br />
Pawan
</div>


Yes see i told you!! Some one must have deleted the index

Great Enjoy!

Bye
Pawan

<div>
The solution has nothing with sql server do do
</div>


The solution has nothing with sql server do do

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
We have some indexes that seems to disappear without any interaction from us.<br />
<br />
One of the indexes is created like this (it has disappered 4 times last month)<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CREATE NONCLUSTERED INDEX IDX_WMSORDERTRANS_HTSYSTEM<wbr /><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON [dbo].[WMSORDERTRANS] ([EXPEDITIONSTATUS],[DATAA<wbr />REAID])<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INCLUDE ([INVENTTRANSID])<br />
<br />
To us it looks standard but still it disappears? <br />
<br />
/Henrik
</div>
</div>


Hi

We have some indexes that seems to disappear without any interaction from us.

One of the indexes is created like this (it has disappered 4 times last month)

	CREATE NONCLUSTERED INDEX IDX_WMSORDERTRANS_HTSYSTEM
	ON [dbo].[WMSORDERTRANS] ([EXPEDITIONSTATUS],[DATAAREAID])
	INCLUDE ([INVENTTRANSID])

To us it looks standard but still it disappears? 

/Henrik

SQL 2008 server indexes dissappears

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.