I am creating a large number of tables and need to create indexes on them. If I execute just one table create sql statement and one index create statement it works fine (so no problem with syntax!) But when I create many tables it comes up with the error:
Cannot find an available index descriptor for an index. Increase the value of 'number of open indexes'. If sp_configure fails due to lack of index descriptors, edit the configuration file and restart the server.
<<< FAILED CREATING INDEX dbo.PROFILE.IND_IDX_1 >>>
Server Message: Number 8424, Severity 17
I need to change the 'number of open indexes' - but how?