dbcc shrinkdatabase (tempdb, 2048)

CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO


DBCC FREEPROCCACHE;
GO


DBCC FREESYSTEMCACHE ('ALL');
GO

DBCC FREESESSIONCACHE;
GO

DBCC SHRINKFILE (TEMPDEV, 200);  
go

DBCC SHRINKFILE (TEMP2, 200);  
go

DBCC SHRINKFILE (TEMP3, 200);  
go

DBCC SHRINKFILE (TEMP4, 200);  
go

DBCC SHRINKFILE (TEMP5, 200);  
go

DBCC SHRINKFILE (TEMP6, 200);  
go

DBCC SHRINKFILE (TEMP7, 200);  
go

DBCC SHRINKFILE (TEMP8, 200);  
go