July 22, 2008 at 2:53 pm
Check if there is any limit to the auto-growth of the data files
configured?
If they are then run the below and try again (I see the table is set auto update still you can give it a try)
DBCC updatestats.
Apart from that can you tell how many records you are processing with this DTS
July 23, 2008 at 7:59 am
Check the auto-grow feature AND if auto-grow is enabled, check the available disk space on the drive where your primary file resides. You're running out of space for some reason. Also, turn off auto-shrink. That's definitely not considered "best practice" and will do more harm than good. Constant shrinking and then growing will lead to file-level fragmentation. If autoshrink is on and autogrow is off, this would eventually lead to the condition you're seeing.
-- You can't be late until you show up.
July 23, 2008 at 8:09 am
If you have other filegroups, you can also move the table to the other filegroup or set the other as the default.
Do not shrink the database regularly.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply