Error: Cannot create or update statistics on view "dbo.Docs" because both FULLSCAN and NORECOMPUT (4225067)

Error: Cannot create or update statistics on view "dbo.Docs" because both FULLSCAN and NORECOMPUT

Error:
Executing the query "UPDATE STATISTICS
> [dbo].[Docs] WITH SAMPLE 50 PERCENT,NORECOMPUTE " failed with the
> following error: "Cannot create or update statistics on view "dbo.Docs" because both FULLSCAN and NORECOMPUTE options are required.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

SAMPLE cannot be used with the FULLSCAN option

FULLSCAN
Compute statistics by scanning all rows in the table or indexed view. FULLSCAN and SAMPLE 100 PERCENT have the same results. FULLSCAN cannot be used with the SAMPLE option.

SAMPLE number { PERCENT | ROWS }
Specifies the approximate percentage or number of rows in the table or indexed view for the query optimizer to use when it updates statistics. For PERCENT, number can be from 0 through 100 and for ROWS, number can be from 0 to the total number of rows. The actual percentage or number of rows the query optimizer samples might not match the percentage or number specified. For example, the query optimizer scans all rows on a data page.

SAMPLE is useful for special cases in which the query plan, based on default sampling, is not optimal. In most situations, it is not necessary to specify SAMPLE because the query optimizer uses sampling and determines the statistically significant sample size by default, as required to create high-quality query plans.

SAMPLE cannot be used with the FULLSCAN option. When neither SAMPLE nor FULLSCAN is specified, the query optimizer uses sampled data and computes the sample size by default.

We recommend against specifying 0 PERCENT or 0 ROWS. When 0 PERCENT or ROWS is specified, the statistics object is updated but does not contain statistics data.



see: http://msdn.microsoft.com/en-us/library/ms187348.aspx