I received the following error message on a SQL 7 system:

 Error: 1105, Severity : 17, State 2
  Can't allocate space for object '%.*s' in database '%.*s' because
the
  '%.*s' segment is full. If you ran out of space in Syslogs, dump the
  transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment
to
  increase the size of the segment.

I know this could happen on SQL 6.5, see Technet Article #Q152354, PSS
ID Number: Q152354, Article last modified on 02-14-2001.

My concern is that I'm seeing this on a SQL 7 database.  Is this still
a problem with SQL 7?  Is there a stored procedure I need to create
and execute to take care of this issue as this is a recurring problem
and just expanding the database/log does not fix this permanently.

Thanks-Derrick

Derrick, do you have the 'auto grow' option turned on for this database? If
not, turn it on, and you will not see this problem.

If you do have 'auto grow' turned and still seeing this error, then probably
you are out of disk space.
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/