| 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 |
|