SQLUSA

Microsoft SQL Server 2005

Best Practices

 

How to use DBCC UPDATEUSAGE?

 

Execute the following script in Query Editor for the current database to update space usage (sp_spacesused) statistics:

Use AdventureWorks;

DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS;


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page