use master
go
set ANSI_DEFAULTS on
go


-- ======================================
-- remove load-time tempdb files
alter database tempdb remove file tempdb1
go
alter database tempdb remove file tempdb2
go
alter database tempdb remove file tempdb3
go
alter database tempdb remove file tempdb4
go
alter database tempdb remove file tempdb5
go
alter database tempdb remove file tempdb6
go
alter database tempdb remove file tempdb7
go
alter database tempdb remove file tempdb8
go
alter database tempdb remove file tempdb9
go
alter database tempdb remove file tempdb10
go
alter database tempdb remove file tempdb11
go
alter database tempdb remove file tempdb12
go
alter database tempdb remove file tempdb13
go
alter database tempdb remove file tempdb14
go
alter database tempdb remove file tempdb15
go
alter database tempdb remove file tempdb16
go
alter database tempdb remove file tempdb17
go
alter database tempdb remove file tempdb18
go
alter database tempdb remove file tempdb19
go
alter database tempdb remove file tempdb20
go
alter database tempdb remove file tempdb21
go
alter database tempdb remove file tempdb22
go
alter database tempdb remove file tempdb23
go
alter database tempdb remove file tempdb24
go

ALTER database tempdb
remove file tempdblogL;
go

ALTER database tempdb
remove file tempdblogL2;
go

-- ======================================
-- remove run-time tempdb files
alter database tempdb 
remove file tempdbR;
go

ALTER database tempdb
remove file tempdblogR;
go


-- =====================================
use tempdb
go
sp_helpfile
go