Updatestats

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 21, 2010 at 6:07 am

  #1182672

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

  -- Gianluca Sartori

• mwhitcom

  Grasshopper

  Points: 10

  More actions

  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.