Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
_WA_sys kind of indexes
Message
De
02/05/2003 20:01:10
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
_WA_sys kind of indexes
Divers
Thread ID:
00784459
Message ID:
00784459
Vues:
83
Hello, everyone

I installed SP3 over standard SQL Server 2000. After reattaching the user databases, they got a lot of indexes, automatically generated. They look like this one: _WA_Sys_cTipSocietate_14D10B8B (cTipSocietate is a column in that table). Alse, they look like regular indexes, but I am unable to get and delete them in Table Properties. The only way to see them is to open sysindexes table or to choose in Enterprise Manager View/Task pad. In this case, clicking on the tab 'Tables' will shows those indexes.

I deleted them manually from sysindexes tables, but the server keeps recreating them. I have to mention till now the database worked withouth them without any problems.

How to get rid of them?

Thank you
Grigore Dolghin
Class Software.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform