March 2, 2007 at 9:56 am
im trying to run a simple query that basically is:
select * from table
order by date_column asc
I keep getting the below error:
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 150636011978752' 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.
I have shrunk the temp db files, added extra files, made sure there was space on the drives but to no avail. one file , no matter how many times i set autogrowth on it, when i go back to the properties it is no longer set to autogrowth. any ideas?
March 2, 2007 at 6:09 pm
It is your order by cluase which is creating the temp table internally...
and looks like you don't have enough space on the disk for tempdb file to grow or it is set to limited growth...
Check the disk space and database options...
If you don't have the space on the disk you can move the tempdb files using alter database command..
Check BOL for command...
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply