Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
MSSQL 6.5 - Can't allocate space for object
0 views
Skip to first unread message
Chmielewski Jacek
Nov 6, 2001, 7:12:48 AM11/6/01
to
Msg 1105, Level 17, State 1
Can't allocate space for object '-642' 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 1510, Level 17, State 2
Sort failed: Out of space or locks in database 'tempdb'
Can't allocate space for object '-642' 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 1510, Level 17, State 2
Sort failed: Out of space or locks in database 'tempdb'
What can I do about it ?
Thanks for all hints
Jacek
Erland Sommarskog
Nov 6, 2001, 6:06:55 PM11/6/01
to
[posted and mailed, please reply in news]
Increase the size of tempdb or take a stab with the query that caused
this. I believe that the object in question is a worktable and this
could be an indication of a malformed query. But do the latter only,
if you believe that already have made tempdb reasonbly big.
--
Erland Sommarskog, Abaris AB
som...@algonet.se
SQL Server MVP
Fuzzy
Nov 6, 2001, 7:25:49 PM11/6/01
to
"Chmielewski Jacek" <jac...@mail.atr.bydgoszcz.pl> wrote in message news:<9s8gfa$cs0$1...@flis.man.torun.pl>...
Your tempdb is not big enough to handle the sort your query requires.
Increase the size of the tempdb.
Ciao
Fuzzy
:-)
0 new messages