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:44 pm
#984693
Run this and let us know the values for size.
use [tempdb]
go
select * from sys.database_files
select * from sys.master_files where database_id = 2