Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-11-16 : 16:59:45
|
| We got this error on sql server 6.5.What should we do.How do i increase the size of tempdb.Error 10015QWDCO32: Failed to save Table:f_call_entry_ext#1.call:Database Error:In <>SQL10007:Server Error:Can't allocate space for object 'calls' in database 'prod' because the 'default'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.Thanks.Rita |
|
|
RocketScientist
Official SQLTeam Chef
85 Posts |
Posted - 2001-11-28 : 17:20:36
|
| It isn't a problem with TempDB, it looks like it's in the database called "prod" on the data device. You need to expand that database, first by expanding the device size (using DISK RESIZE) and then alter the database with ALTER DATABASE to use the new space. Changing the size of TempDB, by the way, uses the same procedure. |
 |
|
|
|
|
|
got this error in sql 6.5