Adam Bean (4/27/2009)

---

Steve Jones - Editor (4/27/2009)

---

Are you sure there's free space in there? Perhaps there are temp objects preventing it from shrinking?

Good call, run this to verify:

USE [tempdb]

SELECT

[name]

,CONVERT(NUMERIC(10,2),ROUND(/128.,2))AS [Size]

,CONVERT(NUMERIC(10,2),ROUND(FILEPROPERTY([name],'SpaceUsed')/128.,2))AS [Used]

,CONVERT(NUMERIC(10,2),ROUND((-FILEPROPERTY([name],'SpaceUsed'))/128.,2))AS [Unused]

FROM [sys].[database_files]