Tonight I submitted a utility I wrote for Microsoft Navision to the Mibuso (http://www.mibuso.com/) website for inclusion in their directory. Hopefully they will post it!

You can view the description of the utility below:

SQL Clustered Index Fix is a utility that I wrote to fix the SQL Clustered Index Issue for a Navision 4.0 SP1 database. It is not implemented in C/AL but Visual Basic 6 working directly at the SQL Server level. This inherently means that Navision will not report the indexes as clustered, but as long as any changed objects are re-indexed it should not be an issue.

This utility has only been safely executed on Navision 4.0 SP1 databases running on SQL Server 2000.

It is recommended that you download the latest MDAC before using this utility:
http://www.microsoft.com/downloads/details.aspx?DisplayLang=en&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

If you are interested in downloading the utility, you can get a copy at the following link:
http://www.codeworxdesign.com/bkn/sqlclusterfix-install.asp

If you are curious about the source code, you can get a copy at the following link:
http://www.codeworxdesign.com/bkn/sqlclusterfix-src.asp

I know some people will be interested why I chose to write the utility in VB6 vs. C/AL. And the main reason is because I am currently only learning the C/AL language. I can modify and work with pre-existing code and even write some code if I have examples and such, but the Clustered Index Fix was derived out of necessity and I felt most comfortable using VB6.

As a note, when this program was executed against a production system with a > 40 GB database it took roughly 4 hours to cluster the indexes.

If you experience any issues with the program, please feel free to contact me by leaving a comment.

~ Bobby