<div>
i have already checked that but for some reasons the update stats doesn't run automatically on sql server 7.0 and also the parameters u specified 'auto update statistics' and 'auto create statistics' is set to ON.<br />
<br />
suggest me something else pls<br />
cryptosid
</div>


i have already checked that but for some reasons the update stats doesn't run automatically on sql server 7.0 and also the parameters u specified 'auto update statistics' and 'auto create statistics' is set to ON.

suggest me something else pls
cryptosid

<div>
I know my previous comment &nbsp;sounded little wierd but that's the truth inspite of the above things set correctly the auto update statistics doesn't give me full hundered percent updation and in fact it doesn't allow me to set it to 100%...<br />
<br />
So currently i do things at db level...i run a daily job on the Database to update statistics on the Database level...<br />
<br />

</div>


I know my previous comment  sounded little wierd but that's the truth inspite of the above things set correctly the auto update statistics doesn't give me full hundered percent updation and in fact it doesn't allow me to set it to 100%...

So currently i do things at db level...i run a daily job on the Database to update statistics on the Database level...



<div>
<div class="content wysiwyg-content">
hello experts...<br />
I have a 4.0B PRD system running on a SQL SERVER 7.0 running on Windows NT 4.0<br />
<br />
i want to run a UPDATE STATISTICS on the database on a daily basis with FULL SCAN and not 13% that SAP has is there any configuration parameter or some setting that i can change to cause the effect..i am aware of DB13 options they don't provide me to set the SCAN %age <br />
<br />
pls help<br />
cryptosid
</div>
</div>


hello experts...
I have a 4.0B PRD system running on a SQL SERVER 7.0 running on Windows NT 4.0

i want to run a UPDATE STATISTICS on the database on a daily basis with FULL SCAN and not 13% that SAP has is there any configuration parameter or some setting that i can change to cause the effect..i am aware of DB13 options they don't provide me to set the SCAN %age 

pls help
cryptosid

BASIS QUESTION

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.