Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help Required

Author  Topic 

nirene
Yak Posting Veteran

98 Posts

Posted - 2007-10-26 : 03:06:47
Hello All,
When I execute my SP it throws an error.

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

Any help is apperciated.

Nirene

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-26 : 03:17:21
Backup and truncate logfile.
How? See this topic http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210
It has many examples how to-s.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-27 : 00:15:48
Did you let tempdb data file auto grow? Has free space on the disk?
Go to Top of Page
   

- Advertisement -