Post reply

creating procedure error

  • October 22, 2008 at 9:15 pm

    #192516

    i creating procedure,i got this error how to solve it

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

  • October 22, 2008 at 11:06 pm

    #888453

    To confirm the reason given in error message use following commands by selecting tempdb

    DBCC showfilestats

    sp_spaceused

    DBCC CHECKALLOC

    sp_helpdb tempdb

    If it is confirm that issue is due to full file group of temp db then look for cure and prevention.

    DBDigger Microsoft Data Platform Consultancy.

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

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