How bout this:

sp_attach_single_file_db @dbname= 'databasename', @physname= 'C:\Users\Documents\Databases\databasefile.mdf'

to reattach the file then empty it then detach the file and delete?

Yes, the server had to many tempdb files some where dropped etc.. etc.. then my space was getting a little low and I looked the temp files are still there...

There no other way a back door into sql sevrer to have the system let go of a particular file?

I have a data file to a database that has been dropped. But it still excist on the file system and can not be deleted because it is still open...

I agree that 300 seconds is only a microsoft recommendation not a requirement. I have a server that stays below that quite often could it use more memory sure is...

GilaMonster you seem to know what your talking about! I really appreciate the feed back!

Hey sean I understand and said I agree with you about the distinct. I was pointing out the fact of that people make mistakes and if the 3 rows i...

Let me make sure that I understand that you are only talking about data files of the tempdb and not the Log files?

Thanks that helps me clearify and what i am faced with!

What if that PageIOLatch is at 2:1:107 ?

That was a good article, but it just goes to show that you may or may not need to do something on your system that some one else has done....

I do agree with you Sean a select distinct will always work assuming that a user has not entered data Incorrectly. My example was assuming that the 3 rows I...

OK sounds like i am on the right track. But lets get a little deeper with the tempdb number of files to CPU. What files data files or Log files...

Hey Sean

The only thing is that a distinct does not always work. If some user entered in the same row with only a space different in one of the...

Then I would start with the data it sounds like there is something like spaces or hidden characters have you copy and pasted some of the values in a text...