Description:
How should the 'DsmMsSqlOpt.bat' script be executed on MDB server with MS SQL 2005. The "Implementation Guide" describe how to run it on a MDB server with MS SQL 2000, with the parameters "-maxfrag=30 -userindex", is this same for a version 2005?
Should there be any other parameters when not using the "default" instance and not using the "default" Ms Sql port? Cause we have a named instance and running are not running on standard port 1433.
Solution:
Run the script with the following parameter
\DsmMsSqlOpt.bat %hostname%\%instance%