Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    78

    Question Unanswered: What does these error message mean?

    Is there any problems with the SQL statements I wrote or is it the computer's problem. Why do I get these messages?

    Please let me know, thank you

    Msg 1105, Level 17, State 2, Line 3
    Could not allocate space for object 'dbo.SORT temporary run storage: 140738350415872' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    Msg 9002, Level 17, State 4, Line 3
    The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Most commonly: Your system drive is full, no space left . More specifically: The drive hosting the files for your temporary database (tempdb) is out of space.

    Tempdb is among others used for temporary objects, cursors, row versioning and sorting of data.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Jul 2011
    Posts
    78
    Thank you for the response

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •