Could not allocate new page for database TEMPDB?

"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 get this error when running a query on another database. But why?

Both data and transaction files on TEMPDB are set to "automatically grow file" and "unrestricted file growth" and there is 70GB of free space on the disk drive. Shouldn't the files just grow? Why would this happen?because temporary table store in tempdb|||because temporary table store in tempdb

Thanks for the reply. I don't understand what you are saying but it sounds like you know what the issue is. Could you please elaborate a little bit?|||You say ：I get this error when running a query
you are running a query , can you show me the query ?
do you create temporary table in your query?|||You say ：I get this error when running a query
you are running a query , can you show me the query ?
do you create temporary table in your query?

No, I'm not explicitly doing anything with TEMPDB.

My query is very straight forward:

SELECT TOP 100 SampleDescriptor, COUNT(*) RepCount FROM DataSamples GROUP BY SampleDescriptor ORDER BY RepCount DESC

On my dev system, with 30 test records, this works fine.

On the production server with 188 million records (yes, a LOT of records!), this fails with the TEMPDB error that I mentioned.

I'm trying a simple: SELECT COUNT(*) FROM DataSamples now. It's been running for over 30 minutes and still going. I wonder if it will hit a similar error...|||When you get the error, have you checked the size of tempdb (both data and log) and free space of the hard drive?

I assume that tempdb is located in the hard drive with 70GB free space.|||Yes, of course. The size of both tempdb data and transaction files are 2MB and they are located on the drive with 68GB free. All drives on that system have plenty of space (although for tempdb, D: should be the only one that matters):

C: has 25 GB free
D: has 68 GB free
E: has 124 GB free|||What do sp_spaceused and sp_helpdb return?

BTW, which version and service pack of SQL Server?

Could anyone intimate with MS Reporting Services help? MSFT? MVP

Is it true that the Full Product of SQL Server Reporting Services is
available for download.....LICENSE -FEE- FREE?! I just want to verify that
there are no "catch" or "hidden" fees or license fees that I have overlooked
(beyond the Reporting Services web-site). As long as I have at least one
licensed version of SQL Server 2000 Stand., Ent.
etc................Reporting Services is free'?
Thank you for any verification.That is correct. However to create reports you will need Visual Studio
.NET. Any edition, even the smallest one, like Visual Studio .NET VB.
"Me" <Me@.discussions.microsoft.com> wrote in message
news:0F6D8668-EB82-44FE-AF65-B074ED09E49F@.microsoft.com...
> Is it true that the Full Product of SQL Server Reporting Services is
> available for download.....LICENSE -FEE- FREE?! I just want to verify
that
> there are no "catch" or "hidden" fees or license fees that I have
overlooked
> (beyond the Reporting Services web-site). As long as I have at least one
> licensed version of SQL Server 2000 Stand., Ent.
> etc................Reporting Services is free'?
> Thank you for any verification.|||Thank you for your help.
"AshVsAOD" wrote:
> That is correct. However to create reports you will need Visual Studio
> ..NET. Any edition, even the smallest one, like Visual Studio .NET VB.
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:0F6D8668-EB82-44FE-AF65-B074ED09E49F@.microsoft.com...
> > Is it true that the Full Product of SQL Server Reporting Services is
> > available for download.....LICENSE -FEE- FREE?! I just want to verify
> that
> > there are no "catch" or "hidden" fees or license fees that I have
> overlooked
> > (beyond the Reporting Services web-site). As long as I have at least one
> > licensed version of SQL Server 2000 Stand., Ent.
> > etc................Reporting Services is free'?
> >
> > Thank you for any verification.
>
>|||It's not quite that simple. Is it ever? :-) The following is from
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp:
Q. Is Reporting Services free?
A. No. Reporting Services is part of the SQL Server 2000 license. If
you have a licensed copy of SQL Server 2000, you may run Reporting Services
on the same server for no additional license fee. If you want to run
Reporting Services on a server that is not licensed for SQL Server 2000, you
will need to obtain a SQL Server 2000 license for that additional server.
This is the same licensing model used for SQL Server Analysis Services. For
more information about licensing scenarios, see the How to License Reporting
Services page.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"AshVsAOD" <.> wrote in message
news:eB7r4smhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> That is correct. However to create reports you will need Visual Studio
> .NET. Any edition, even the smallest one, like Visual Studio .NET VB.
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:0F6D8668-EB82-44FE-AF65-B074ED09E49F@.microsoft.com...
>> Is it true that the Full Product of SQL Server Reporting Services is
>> available for download.....LICENSE -FEE- FREE?! I just want to verify
> that
>> there are no "catch" or "hidden" fees or license fees that I have
> overlooked
>> (beyond the Reporting Services web-site). As long as I have at least one
>> licensed version of SQL Server 2000 Stand., Ent.
>> etc................Reporting Services is free'?
>> Thank you for any verification.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end|||Thank you very much for that verification.....!
MSFT feedback is very much appreciated.
"Stephen Dybing [MSFT]" wrote:
> It's not quite that simple. Is it ever? :-) The following is from
> http://www.microsoft.com/sql/reporting/howtobuy/faq.asp:
> Q. Is Reporting Services free?
> A. No. Reporting Services is part of the SQL Server 2000 license. If
> you have a licensed copy of SQL Server 2000, you may run Reporting Services
> on the same server for no additional license fee. If you want to run
> Reporting Services on a server that is not licensed for SQL Server 2000, you
> will need to obtain a SQL Server 2000 license for that additional server.
> This is the same licensing model used for SQL Server Analysis Services. For
> more information about licensing scenarios, see the How to License Reporting
> Services page.
>
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "AshVsAOD" <.> wrote in message
> news:eB7r4smhEHA.3320@.TK2MSFTNGP11.phx.gbl...
> > That is correct. However to create reports you will need Visual Studio
> > .NET. Any edition, even the smallest one, like Visual Studio .NET VB.
> > "Me" <Me@.discussions.microsoft.com> wrote in message
> > news:0F6D8668-EB82-44FE-AF65-B074ED09E49F@.microsoft.com...
> >> Is it true that the Full Product of SQL Server Reporting Services is
> >> available for download.....LICENSE -FEE- FREE?! I just want to verify
> > that
> >> there are no "catch" or "hidden" fees or license fees that I have
> > overlooked
> >> (beyond the Reporting Services web-site). As long as I have at least one
> >> licensed version of SQL Server 2000 Stand., Ent.
> >> etc................Reporting Services is free'?
> >>
> >> Thank you for any verification.
> >
> >
>
>