Home Forums SQL Server 2005 Administering Problem with statistics RE: Problem with statistics

  • February 16, 2011 at 11:25 am

    #1287816

    I just used this: -

    USE <database name>;

    GO

    ALTER DATABASE <database name>

    SET AUTO_CREATE_STATISTICS ON;

    ALTER DATABASE <database name>

    SET AUTO_UPDATE_STATISTICS ON;

    GO

    and it seems to fix the problem as the warning sign is gone now