Home Forums SQL Server 2005 Administering why i can't shrink tempdb data file RE: why i can't shrink tempdb data file
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 27, 2009 at 2:09 pm
#984673
Try running this query and see what is out there in tempdb:
select * from tempdb.sys.all_objects
where is_ms_shipped = 0;