Shrink TempDB

Hi

Just a quick note: One of my colleagues ran massive updates through SSIS. Eventually the package "fell over" with the error message that the TEMPDB couldn't allocate more hard drive space to the page - the hard drive space. We got techie on the problem, but no DBCC Shrink_XXX commands helped. Eventually he found the (OH SO OBVIOUS) solution - restart the SQL Service...

Now you know too...

Z