Error 1101

• anbu

  SSC-Addicted

  Points: 407

  More actions

  May 12, 2003 at 12:51 am

  #58489

  Hi,

  How can I get rid of this error:

  Executed as user: OLVINET\Administrator. Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth. [SQLSTATE 42000] (Error 1101). The step failed.

  Please reply me soon.

  Thanks in advance.

  Anbu

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  May 12, 2003 at 1:20 am

  #456787

  You need to increase the size of your 'tempdb' database.

  Either increase the size manually via Enterprise Manager, or check the box to allow Auto Grow.