“There is not enough memory in the procedure cache”

If you see the error message there is not enough memory in the procedure cache during the migration of indexes, use sp_configure procedure cache size to increase the procedure cache.