July 20, 2006 at 2:20 pm
Can this error message be ignored or something or the procedure is bad ...
No columns without statistics found. [SQLSTATE 01000] (Message 15013)
Table 'Prod.dbo.zi_hi: No columns without statistics found.
The jobs turns out as failed is this something to worry about ?
Thanks
July 20, 2006 at 2:30 pm
Doubtful. From BOL:
"
Columns that already have statistics are not touched; for example, the first column of an index or a column with explicitly created statistics. A CREATE STATISTICS statement is executed for each column that satisfies the previous restrictions. FULLSCAN is executed if fullscan is specified.
Statistics are not created on columns that are the leading columns of disabled indexes. When indexonly is specified, statistics are not created on a column in a disabled nonclustered index, unless that column is also used in another enabled index. sp_createstats ignores tables with a disabled clustered index."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply