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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 6.5

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-06 : 00:36:54
Roman writes "Hello,

We have a 6.5 SQL DB when I run a query the error appears...

Msg 1105, Level 17, State 1
Can't allocate space for object '-386' in database 'tempdb' because the 'system' 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.
Msg 21, Level 20, State 1
WARNING - Fatal Error 1510 occurred at Aug 1 2001 7:18PM. Please note the error and time, and contact your System Administrator.

I am at my wits end to figure this out. I did a large "dbcc dbreindex tablename" and it crahsed. The message this morning was too quick to read - something about drop.

All help would be appreciated."
   

- Advertisement -