Post reply

Updatestats

  • June 17, 2010 at 12:25 pm

    #236611

    Hi,

    I'm running the below command after upgrading the SQL Server 2005 database to 2008 to update the stats:

    Use MyDB

    go

    SP_UPDATESTATS

    GO

    But it displaying all the information messages as below. What should I do NOT to display the informational messages?

    Updating [dbo].[pdfDelivery]

    [PK_pdfDelivery] has been updated...

    [IX_pdfDelivery] has been updated...

    [IX_pdfDelivery_1] has been updated...

    Thanks

  • June 21, 2010 at 6:07 am

    #1182672

    I'm sorry, there's no way to prevent the messages from printing out.

    -- Gianluca Sartori

  • June 21, 2010 at 10:57 am

    #1182863

    Maybe try making a new sp_updatestats2 and remove the output? I did this to further refine sp_who2 into sp_who3. The code is right there in the database, this is not an extended sp.

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

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