SQLServerCentral / Administration / SQL Server 7,2000 / Sql 2000, Database don't have available space / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:34:52 GMT20RE: Sql 2000, Database don't have available spacehttp://www.sqlservercentral.com/Forums/Topic598671-5-1.aspxThanks Raghavender, After executing dbcc updateusages (0), database really changed space available.Sat, 08 Nov 2008 01:40:29 GMTananda.murugesanRE: Sql 2000, Database don't have available spacehttp://www.sqlservercentral.com/Forums/Topic598671-5-1.aspxtry by running below query:DBCC updateusage 'DBNAme'check the propertiesThanksRegardsFri, 07 Nov 2008 13:20:35 GMTRaghavenderRE: Sql 2000, Database don't have available spacehttp://www.sqlservercentral.com/Forums/Topic598671-5-1.aspxWhere exactly you are checking for space usage:Taskpad, thru Command or ?MJFri, 07 Nov 2008 12:57:21 GMTMANU-J.Sql 2000, Database don't have available spacehttp://www.sqlservercentral.com/Forums/Topic598671-5-1.aspxHi,Past five years back ,Some one has created one database in sql server 2000, so i noted this database properites as followsstatus - Normalowner -sadate created - 2/3/2002size -4654.12 mbspace available -0.00 mbno.of user - 10And database datafile properites file growthIn Megabytes - 50restrict file growth - 4200So what i want , need to be increase space available this database, please help me how to change space available?I had tried and default setting for automatically grow file, By precent 10 and Unrestricted file growth but it was not hope. still space available 0.00 MB and database does not changed in change space available.Thu, 06 Nov 2008 22:29:06 GMTananda.murugesan