Home Forums SQL Server 2008 SQL Server 2008 Administration Index optimization failed for User databases RE: Index optimization failed for User databases
Ant-Green
SSC Guru
Points: 113445
More actions
January 2, 2013 at 3:31 am
#1572794
You have index(s) with a - in their name. If the script does not put the index name in [] brackets when rebuilding/reorganising, then the script will fail.
Either change the index(s) name, or change the script to wrap [] around the index(s).