General SQL server error

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Error number -9:

DMS-E-GENERAL, A general exception has occurred during operation 'open result'. Can't allocate space for object '-323' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. DMS-E-GENERAL, A general exception has occurred during operation 'open result'. Sort failed: Out of space or locks in database 'tempdb' DMS-E-GENERAL, A general exception has occurred during operation 'open result'. General SQL Server error: Check messages from the SQL Server.

-- Anonymous, November 17, 1998

Answers

Re: General SQL server error

Robert,

The message says you ran out of room in the system segment, NOT the log segment. The rest of the message says IF you ran out of room in Syslogs, which is the log segment, dump the log. But since you didn't run out of room in the log segment, clearing it won't help. Your problem is not the logging. Your tempdb itself is just too small. How big is it? If you never increased it beyond the initial 2 MB, it is WAY too small. You can enlarge it with the Enterprise Manager Edit Database screen, or using the ALTER DATABASE statement after creating a new device.

Good Luck,

Eric

-- Anonymous, November 17, 1998


Moderation questions? read the FAQ