I'm using SQL Server 6.0.
I was running an application to insert into "TableX" and received the
following error message:
"Can't allocate space for TableX because the default segment is full. If
you ran out of space in syslogs, dump transaction log. Otherwise, use
Alter Database or sp_extendsegment to increase the size of the segment."
My transaction log is not full. I have only used 9% of it. I increased
the size my database by 30 megabytes. But, I am still getting this
So, it appears that increasing the database size does not affect the default
segment. What is the "default segment"? Is it the same thing as the default
Thanks in advance for your help.