Post reply

retreiving data from tempdb

  • July 8, 2008 at 8:30 am

    #96499

    Hi,

    I am trying to retreive data from a temporary table which I have inserted into in the same sp.

    I get this error.

    Could not allocate space for object 'dbo.SORT temporary run storage: 190806775300096' 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.

    There is space in tempdb data and log file. nothing else is running on the server at the time. there is space on the disk. log_reuse_wait_desc is stated as NOTHING. I've stopped and started sql server to empty tempdb

    Any ideas?

    thanks

    Adrian

  • July 8, 2008 at 8:34 am

    #839532

    Hi

    Could you please run the following command and post the results here?

    sp_helpdb tempdb

    Tal Ben Yosef
    www.TalBenYosef.com
    (visit my LinkedIn profile)

  • July 8, 2008 at 8:38 am

    #839534

    thanks for your quick reply!

    tempdb 2048.00 MBsa2Jul 8 2008Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics90

    tempdev1x:\MSSQL\DATA\tempdb.mdfPRIMARY1048576 KBUnlimited10240 KBdata only

    templog2y:\MSSQL\DATA\templog.ldfNULL1048576 KBUnlimited10240 KBlog only

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply