In this blog post, let’s learn about the error message “8605 – Index creation operation will use %ld KB of memory specified in the advanced sp_configure option “min memory per query (KB)” instead of %lu KB specified in “index create memory (KB)” option because the former has to be smaller than the latter.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
8605 – Index creation operation will use %ld KB of memory specified in the advanced sp_configure option “min memory per query (KB)” instead of %lu KB specified in “index create memory (KB)” option because the former has to be smaller than the latter.
Reason for the Error
To be update soon…
Solution
To be update soon…