March 27, 2008 at 11:22 am
when i run a query with multiple joins in ssms i got this error
Msg 1105, Level 17, State 2, Line 13
Could not allocate space for object 'dbo.SORT temporary run storage: 187265217724416' 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.
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 27, 2008 at 12:28 pm
Looks like tempdb ran out of space.
Either you ran a query against such a large amount of data that you maxed out your tempdb or you may have something wrong with the query. Can you post it?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply