
SQL 7 Error Message: Error: 1105, Severity : 17, State 2
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/
Quote:
> 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