Post reply

dbcc updateusage(0),sp_updatestats "urgent"

  • June 3, 2009 at 8:09 am

    #134776

    dbcc updateusage(0),sp_updatestats

    please advise me for wat we are running this command after restoring a database urgent

  • June 3, 2009 at 9:10 am

    #1004107

    Books online is your friend

    http://msdn.microsoft.com/en-us/library/ms130214.aspx

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • June 3, 2009 at 9:17 am

    #1004114

    Not sure why your running it but BOL yields all the information that you are seeking.....

    DBCC UPDATEUSAGE

    Reports and corrects inaccuracies in the sysindexes table, which may result in incorrect space usage reports by the sp_spaceused system stored procedure.

    sp_updatestats

    Runs UPDATE STATISTICS against all user-defined tables in the current database.

    Edit: And Robert is 100% correct - he obviously posted while I was composing my reply! 😉

    -- You can't be late until you show up.

  • June 3, 2009 at 9:21 am

    #1004119

    Whats so urgent, did u or some maintenance job run CHECKDB and got info message from SQL to run those commands?

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

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