• when i run the DBCC SHRINKFILE i get this error message

    DBCC SHRINKFILE: Page 1:3740312 could not be moved because it is a work table page.

    but the free space on the tempdb is 29GB.

    how can i know what i keeping my tempdb busy,so i can't shrink it?

    sp_spaceused =

    database_name database_size unallocated space

    -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------

    tempdb 29971.25 MB 29219.73 MB

    reserved data index_size unused

    ------------------ ------------------ ------------------ ------------------

    1560 KB 648 KB 712 KB 200 KB