increasing a Data Base Size in Sql 2000

Start with by checking the logical names and attributes of the datafile and log file associated with your database, use sp_helpfile stored procedure like these:

USE [master]
GO
Exec sp_helpfile
Go

You should be able to see the size of your data and log files.

If you dont have space on the disk make sure you free up some space or move your files to a bigger disk space. But if the autogrowth is not turned on and the data is full you can go to Studio Management and right click on the database in question, select properties then on the left side choose Files. Then you can change the database size accordingly.

Or you can use the following ALTER DATABASE statement by changing the Database name, your data and log file along with your new size.

USE [master]
GO
ALTER DATABASE [Your Database Name] MODIFY FILE ( NAME = N'YOur Data File', SIZE = 51200KB )
GO
ALTER DATABASE [Your Database Name] MODIFY FILE ( NAME = N'Yourlogfile_log', SIZE = 1024KB )
GO

Dont depend on autogrow, make sure you plan the size of your databases ahead. Also if your databases are in FULL Recovery mode, make sure to properly maintain the transaction log.

Good Luck!

You can do this either using Enterprise Manager or T-SQL. Both are explained in MSDN.

Enterprise Manager:
http://msdn.microsoft.com/en-us/library/aa197143%28SQL.80%29.aspx

T-SQL (use ALTER DATABASE):
http://msdn.microsoft.com/en-us/library/aa275464%28SQL.80%29.aspx
Here's an example from the article for increasing the size of a database file:

USE master
GO
ALTER DATABASE Test1 
MODIFY FILE
   (NAME = test1dat3,
   SIZE = 20MB)
GO