Could not allocate space for object 'dbo.SORT temporary run storage
Posted on 2010-08-18
I need to make an update to the size of a field in a table changing the length from 220 to 255.
When making the change in the design mode I come accross the following error
- Unable to create index 'PK_GlobalFeed'.
Could not allocate space for object 'dbo.SORT temporary run storage: 140737489600512' in database 'MyDatabase' 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.
Could not create constraint. See previous errors.
The statement has been terminated.
I am not sure of the terminoligy of what I am required to do. looking at my system resources it appears that I have plent of spare space. the database size is 2.6gb on sql express 2008 so well within the 4gb limts. I don't know how to set the auto growth as sugested either.
Can anyone simplify the message as to what I should do to free up the space.