Error 1101

• anbu

  Old Hand

  Points: 347

  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.