Post reply

update stats failing on SQL 2005

  • November 22, 2011 at 7:16 am

    #248327

    SQL server 2005, sp4 enterprise edition 64 bit.

    Update stats error as below

    Cannot create or update statistics on view because both FULLSCAN and NORECOMPUTE options are required

    I know these errors were resolved in SP3 but I still get this error on Sp4 any idea why?

    Thanks in advance!

  • November 22, 2011 at 9:51 am

    #1411650

    Can you post the command you tried?

    -- Gianluca Sartori

  • November 22, 2011 at 10:50 am

    #1411694

    update stats is scheduled using Light speed .

    I've attached the screenshot for you.

  • November 22, 2011 at 10:51 am

    #1411697

    Please post as jpg, I don't open vba activated files from programmers!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply