Microsoft KB Archive/819953

= PRB: Auto Created Statistics Are Sampled by Using a Specified Sampling Rate =

Article ID: 819953

Article Last Modified on 5/16/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
If you update the statistics in a table and specify a sampling rate that is less than 100 percent, the index statistics are updated by using a 100 percent sample, but the auto created statistics are updated by using the specified sampling rate. You may experience this problem when you run the following Transact-SQL statement: UPDATE STATISTICS >_< > (where < > is the object_id of the table in hexadecimal format).

