<div>
tempdb is a SQL Server internal DB, used for holding temporary tables and other internal purposes by SQL Server (such as temporary tables for Order By clauses)<br />
<br />
Try increasing the size of tempdb, or removing the growth restriction (if you set one up for it)<br />
<br />
You should also schedule and Shrink Database and Truncate Log activity for the DB on a regular basis. &nbsp;Enterprise manager makes this simple.<br />
<br />
<br />

</div>


tempdb is a SQL Server internal DB, used for holding temporary tables and other internal purposes by SQL Server (such as temporary tables for Order By clauses)

Try increasing the size of tempdb, or removing the growth restriction (if you set one up for it)

You should also schedule and Shrink Database and Truncate Log activity for the DB on a regular basis.  Enterprise manager makes this simple.




<div>
<div class="content wysiwyg-content">
I am hitting a new db installation from Delphi 5 through ODBC.<br />
<br />
The 13059 error I get comes up when I open a project I moved to a new<br />
computer. &nbsp;It says: &nbsp;General SQL error. &nbsp;[Microsoft][ODBC SQL Server<br />
Driver][SQL Server]Can't allocate space for object '-385' in database<br />
'tempdb' because the 'system segment is full. If you ran out of space in<br />
Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or<br />
sp_extendsegment to increase the size of the segment.<br />
<br />
I am not even using this database as part of my project, but I am not able to make it bigger and truncating it does no good. &nbsp;Is there a trick here that I am not seeing?<br />
<br />
Thanks<br />
Phil
</div>
</div>


I am hitting a new db installation from Delphi 5 through ODBC.

The 13059 error I get comes up when I open a project I moved to a new
computer.  It says:  General SQL error.  [Microsoft][ODBC SQL Server
Driver][SQL Server]Can't allocate space for object '-385' 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.

I am not even using this database as part of my project, but I am not able to make it bigger and truncating it does no good.  Is there a trick here that I am not seeing?

Thanks
Phil

tempdb space error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.