Hello,
We have installed BaaN IV c4 ,and service pack and SQL 2000,Win 2003.

We want to set parameter seetings for SQL server.(optimal performance)
through query analyser

ex:
excute sp_configure "show advanced options",1 reconfigure with override
exceute sp_configure "max degree of parallelism:,1
execute sp_configure "priority boost"0 .....

We are not sure whether this was installed during the installation. is there any way to check or if we execute above statement will there be any impact.

Please advice.

Thanks in advance.
UK

Dear Mr. Mahadevan,

Even if u run these optimization statements more than once, the are not going to do anything bad.

Regards,
Vishal