As per script table = indexstats is missing. need script to creat this table = indexstats
Who tested this script and how? It fails to create dependencies on SQL 2005 on Win2003 R2 x64. If you ignore that error and try to execute the sp, then you realize - as the previous poster had pointed out - the script is trying to access a table called indexstats, and that table does not exist. Way to go team sql scriptors :))
Hey guys, I might be too late to answer your question but still I thought it might be useful. The reason why the scripts is lacking the indexstats is because this table is created in a related script. I give you the two scripts and their utility: - http://gallery.technet.microso ft.com/scriptce nter/2e6a15f5-a e04-4f76-ab15-b 6141d7b1811. this one is the create/truncate indexstats which is referred as step 1 - http://gallery. technet.microso ft.com/scriptce nter/448a25dd-e e80-4345-90f1-2 8d479bbfa5f. This one is the retrieve index statistics which is referred as step 2 and 4. Hope it will help someone Cheers Fred