Search

Thursday, July 28, 2011

code to run updateusage against all databases

exec sp_msforeachdb 'DBCC UPDATEUSAGE(?)'
Posted by at

1 comment:

  1. UnknownDecember 9, 2016 at 3:02 PM

    thanks, you may go through the following link. which explains when to run this DBCC UPDATEUSAGE:
    http://www.sqlmvp.org/running-dbcc-updateusage-in-sql-server/

    ReplyDelete

Subscribe to: Post Comments (Atom)