I have numerous tables on a SQLServer 7.0 database exhibiting this feature.
If I use
Enterprise Manager (open database,open tables,All Tasks,Manage Indexes) or
generate SQL Scripts, these indexes do NOT appear. But if I execute
sp_helpindex or rebuild indexes, they are listed and they all have names
which start with '_WA_SYS_'.
Has anyone else seen this or know where they came from?
History of this SQLServer:
I converted this SQLServer 6.5 database to 7.0 several weeks ago.
Initially I did a 7.0 upgrade on the server. However, because of some issues
with the security structure conversions ( aliases were used), we had to go
back to the 6.5 databases for awhile until we understood the security
issues. We then transfered the 6.5 data to another 6.5 SQLServer, switched
the production server back to 7.0, and used DTS to restore the data. We
have been running successfully in the 7.0...then I noticed
Any ideas? TIA, Linda