Could not allocate space for object ''(SYSTEM table id: -683853068)'' in database ''TEMPDB'' because the ''DEFAULT'' filegroup is full..

• Praveen Kurup

  SSChasing Mays

  Points: 613

  More actions

  November 18, 2005 at 5:21 am

  #88559

  I am trying to Input around 45k records using SQL Server with RAM configoration of 1GB [2 slot] and SQL SERVER 2000 using SP3a . But I am getting thread on the execution of my program as follows in ERRORLOG :-

  Error: 1105, Severity: 17,

  State: 2 Could not allocate space for object '(SYSTEM table id: -683853068)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full..

  During runtime of my java program I am getting the following ERROR on command prompt saying,"----[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not allocate space for object '(SYSTEM table id: -7658640)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.----"

  Please help me to rectify this THREAD

• November 21, 2005 at 8:00 am

  This was removed by the editor as SPAM

• BeerBeerBeer

  SSCarpal Tunnel

  Points: 4021

  More actions

  November 23, 2005 at 4:54 pm

  #605592

  A couple of possibilities that may or may not be valid.

  You are out of disk space on the drive where your tempDB resides

  You have restricted the growth of the tempDB (this is not the normal setting for tempDB so unless you've ha da play with settings this is unlikely)

  The application user does not have sufficient permissions allow write access to the disk.

  ---

  Regards,

  Steve

  Life without beer is no life at all

  All beer is good, some beers are just better than others