Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Alter

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2005-10-20 : 11:29:36
after Altering the space for the database already created , what can be done inorder to refect in the database .
b'cos i altered the space and it's replecting only in that .MDF file but not in the database taskpad view

Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-20 : 13:41:04
You need to run DBCC UPDATEUSAGE for that database. This corrects the inconsistencies.

Tara
Go to Top of Page
   

- Advertisement -