sp_helpdb 'tempdb'

USE tempdb

GO

DBCC SHRINKFILE (tempdev6, EMPTYFILE)

GO

ALTER DATABASE tempdb

REMOVE FILE tempdev6; --to delete "tempdev6" data file

GO

--