TEMPDB LOG FULL

I don't know much in terms of SQL server, but perhaps you will find what your after in this MS article Troubleshooting Insufficient Disk Space in tempdb.

Is it set to simple recovery mode? I believe this will automatically truncate...

ALTER DATABASE tempdb SET RECOVERY SIMPLE

Is it running out of disk space?

Option 'RECOVERY' cannot be set in database 'TEMPDB'.

plenty of space...

are you  logged in with raised credentials? Do you have permission to change settings?

yes

In SQL Enterprise Manager, right click on the database then choose properties and then Option  and Recovery change from "Full" to "Simple"

It is set to Simple

??

did you shrink and truncate your log file and try it again?

yes.. it then works then I will get TEMBDB LOG FULL after several queries

I have over 300GB of free space on the drive... it makes no sense
Queries return max of 20K records

Msg 208, Level 16, State 1, Line 1
Invalid object name 'tempdb.sys.database_files'.

Guess that doesn't work in 2005 then, so you'll have to use longhand:

use tempdb
go
select * from sys.database_files

Select allOpen in new window

same msg ????????????

In that case just look at the properties in the GUI. Expand System Databases in the Server Explorer, right-click on tempdb, choose Properties and go to the Files page.

36MG    tempdev
1 MG   templog

I'm guessing that is the initial size column. What does the auto growth/max size column say?

autogrowth 10 % unrestricted

In that case it should be growing until the disk runs out of space. Is the disk filling up when you get the log space error message, or is there still free space on the disk?

Plenty of free space 220GB
?