SHRINKFILE TEMPDB failed (work table page)

· Uncategorized
Authors

Today I needed to perform following command prior to deleting a file of TEMPDB:

DBCC SHRINKFILE (N’tempdev02′ , EMPTYFILE)

But received following error:

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

Apparantly, in most cases work tables are related to Query Plans. So running following DBCC solved my problem:

DBCC FREEPROCCACHE

Thanks to Mike Rose

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: