Web Development

Ask something
Discussion Locked

SQL7/2000 Table Info disappeared?!!

0 helpful
10 replies

by ohjani

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

has anyone came across this problem? Normally u can see a list table columns statistic in the Table Info tab when u select a database in Enterprise Manager Console. this statistic show the size of the tables, primary/foreign keys and any other indexes. however, after i did a maintanence on reorganizing the index and keys, this statistics disappeared !! all i got to see at the Table Info tab is "The specified table cannot be found." All the tables and views are still in place, but why the statistics gone?

Database property IsAutoCreateStatistics and IsAutoUpdateStatistics are both set to True. not sure if this info helps.

10 replies

by bojidar alexandrov

Before several months I have a simillar problem - incorect info (dependency) about tables and sprocs. The problem was corrupted info in Master DB. There is all this info about objects in all databases. Teoritically you can manualy examine info thereand correct it, but I solved my problem with recreation of these tables and sprocs that are corrupted.

by alterego2

Autoupdate updates your indexes on a periodic basis the frequency of which is determined by the amount of data being entered. I don't think that re-organizing your index as part of a maintenance job automatically updates the stats.
If you use the UPDATE STATISTICS command to manually update the stats. it should work.

If you have autoupdate stats. turned on then you shouldn't really need to tune the indexes on a regular basis.

by alterego2

Autoupdate updates your indexes on a periodic basis the frequency of which is determined by the amount of data being entered. I don't think that re-organizing your index as part of a maintenance job automatically updates the stats.
If you use the UPDATE STATISTICS command to manually update the stats. it should work.

If you have autoupdate stats. turned on then you shouldn't really need to tune the indexes on a regular basis.

This discussion is closed to new replies.