• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

"Can't allocate spare for object '-419'..."

Dear sir,I get an error where I do a query in asp, system return the msg below:
[Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '-419' 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.
You can notify me by email:yanglihua@yahoo.com
Thank you very much!  
0
lijin1
Asked:
lijin1
  • 2
1 Solution
 
tschill120198Commented:
This means that your tempdb has run out of room for data (i.e., isn't large enough).  Increase it from enterprise manager or by using "alter database" (syntax in BOL).
0
 
Rakesh010499Commented:
Hi,
Your tempdb resides in master database with 2mb of space allocated to it. Try to create the tempdb on a separate device and increase the size of tempdb to say 5mb and also you can try running a task periodically to dump transaction of the tempdb.
Please try it and let me know.

Cheers
Rakesh

0
 
Rakesh010499Commented:
Hi,
Your tempdb resides in master database with 2mb of space allocated to it. Try to create the tempdb on a separate device and increase the size of tempdb to say 5mb and also you can try running a task periodically to dump transaction of the tempdb.
Please try it and let me know.

Cheers
Rakesh

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now