Link to home
Create AccountLog in
Avatar of rito1
rito1

asked on

TEMPDB Filegroup is full

Hi All

I am trying to run the following query from SQL Analyzer and it seems to produce an error which is also below:

SELECT TOP 1 percent *
FROM dbo.tbl1

Error:

Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object '(SYSTEM table id: -789174521)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.

But I can run the following query..

SELECT TOP 5000 *
FROM dbo.tbl1

A little more info...

The database I am running the query in isn't TEMPDB.
The database I am running the query in has unrestricted for both the data file and log.
The table I am running the query on is rather large and has over a million rows.

I have gone to my host and they cannot see anything wrong with SQL Server.

Please could you let me know your thoughts on this and I can share with my host too.

Many thanks

Rit
ASKER CERTIFIED SOLUTION
Avatar of ibrusett
ibrusett
Flag of Italy image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of rito1
rito1

ASKER

thanks ibrusett,
I'll share point 2 with my host.

Rit