Very Computer

by **Linda Bianch** » Fri, 12 Nov 1999 04:00:00

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
this.

Any ideas? TIA, Linda

by **Jackie Broph** » Fri, 12 Nov 1999 04:00:00

These are really statistics. You must have auto create statistics checked in
the db options. You can read more about it in BOL.

Jackie

Quote:> 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
> this.

> Any ideas? TIA, Linda

by **Jerry Spive** » Fri, 12 Nov 1999 04:00:00

Linda - See the prior post from Tom on 11.9.99

JS

Quote:> 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
> this.

> Any ideas? TIA, Linda

Very Computer

Source of Phantom Indexes with names like _WA_SYS% ?

Source of Phantom Indexes with names like _WA_SYS% ?

Source of Phantom Indexes with names like _WA_SYS% ?

Source of Phantom Indexes with names like _WA_SYS% ?