>Dear Friends,
>
>I Have problem with SQL server-2000 the message come up is "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.."
>
>What should I do, need your help urgently
>
>Thanks
>Hendry Setiawan
Try this.
1. Start Enterprise Manager
2. Open SQL Server and right click on TEMPDB
3. Select properties
4. Go to Data Files tab
5. Check Automaticly grow file and Unrestricted file growth
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.