Prev: Errors
Next: Help error 1326
From: Jay on 3 Oct 2006 15:30
I'm using sql server 2005. My tempdb has grown very large, because of
some things I'm doing to QA large amounts of data. I've tried to use
DBCC Shrinkfile(filename) and DBCC ShrinkDatabase (dbname). I receive
the following message:

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

I've never encountered this problem before. I did restart sql server
and attempted to shrink the file once again and I had no luck. Any
help is greatly appreciated. Thanks.


Jay

 | 
Pages: 1
Prev: Errors
Next: Help error 1326