October 8, 2003 at 2:40 pm
HI All
Following error occured during table insert query. 'error minus 2147217900 can't allocate space for object in data base because the default segment is full'. Have you any idea how to clear the default segment and increase the size.
Thanks
October 8, 2003 at 4:05 pm
The default segment is where your data resides, as opposed to the log segment. Techinically, you can have non-defaut data segments, but this is not common.
Anyway, you can 'clear' the default segment by deleting data, but if this is not an option, just expand the space available by expanding a data device, or adding a new device to the database. See SQL Server 6.5 Books Online for details.
October 10, 2003 at 2:07 am
Use the following command to get an accurate idea of the DB's Data and Log size.
DBCC Checktable (syslogs)
Go
sp_spacused
October 10, 2003 at 2:07 am
Use the following command to get an accurate idea of the DB's Data and Log size.
DBCC Checktable (syslogs)
Go
sp_spaceused
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply