sp_createstats breaks if it hits a non-deterministic computed column - by RMJCS

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 519625 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 12/10/2009 11:37:20 AM
Access Restriction Public


sp_createstats errors and exits if it tries to create stats for a non-deterministic computed column. It ought to skip these columns much like it does for other non-stats friendly columns.

I've tried this on SQL Server 2005 32bit Standard SP3 and SQL Server 2008 64bit Developer SP1.

Sign in to post a comment.
Posted by Boris [MSFT] on 4/5/2010 at 2:02 AM

Unfortunately, we will not be fixing this defect in the next Service Pack of SQL Server 2008. As I mentioned before, this has been fixed in the current code base.

Posted by Boris [MSFT] on 12/23/2009 at 5:37 PM
Thank you for reporting the bug!

It has already been fixed in the code base of the next release. This item will reflect its state for the current release, SQL Server 2008 (i.e. it will be updated when the fix makes into the next cumulative update/service pack).

Meanwhile you can consider enabling autostats or creating the stats manually, avoiding this column.

Boris Baryshnikov.
SQL Server Engine