• Temp db full as in occupies all the available disk space? How long has this been the case - as you know temp db does fluctuate in size during normal SQL operation.

    Can you grow the drive temp db is on?

    If not, is a re-start of the SQL service viable - this may not be viable as it is dependant on the availability requirements of you system.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx