| How to
use DBCC UPDATEUSAGE? |
|
Execute the following
Microsoft SQL Server T-SQL script in Query Editor for the current database to update space
usage (sp_spacesused) statistics:
Use AdventureWorks2008;
DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS;
|
|
| |
| |
|