Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Bug
ID: 519625
Opened: 12/10/2009 11:37:20 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

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.

Regards,
Rhys
Details
Sign in to post a comment.
Posted by Microsoft on 4/5/2010 at 2:02 AM
Hello,

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.

Regards,
Boris.
Posted by Microsoft 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.

Regards,
Boris Baryshnikov.
SQL Server Engine
Sign in to post a workaround.