Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temp DB Error when running a SQL Statement
Message
From
11/04/2002 14:42:38
 
 
To
11/04/2002 14:27:03
Christopher Pinnock
United General Insurance Company
Kingston, Jamaica
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00643876
Message ID:
00643890
Views:
18
Maybe quotas are being enforced for the account that the mssqlserver service is running under.

-Mike

>Hey guys really urgent, I got the following error when running a big query.
>
>
>-------- Error
>
>Server: Msg 1101, Level 17, State 10, Line 1
>Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.
>
>
>-------------------
>
>
>I have file groth enabled on the databases including tempdb. What do you think my problem is ?
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform