• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 26
  • Last Modified:

SQL 2008 server indexes dissappears

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
0
HenrikVang
Asked:
HenrikVang
  • 3
  • 2
2 Solutions
 
Pawan KumarDatabase ExpertCommented:
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')

Open in new window


Are you the DB Owner ?
0
 
Pawan KumarDatabase ExpertCommented:
Hi HenrikVang,

Any update on this?

Regards,
Pawan
0
 
HenrikVangCIOAuthor Commented:
Hi Pawan
I just found the solution - our AX2009 cleans all indexes when a table is updated and create only the indexes that is registred in AX and not the ones that was created in SQL management

/Henrik
0
 
Pawan KumarDatabase ExpertCommented:
Yes see i told you!! Some one must have deleted the index

Great Enjoy!

Bye
Pawan
0
 
HenrikVangCIOAuthor Commented:
The solution has nothing with sql server do do
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now