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.