Move all tempdb files

move-tempdb.sql

DECLARE	@original_path		sysname = N'E:\SQLServer\MSSQL15.SQL2022\MSSQL\DATA';
DECLARE	@destination_path	sysname = N'E:\SQLServer\MSSQL16.SQL2022\MSSQL\DATA';


DECLARE	@sqlcmd nvarchar(max) = (
SELECT
		N'ALTER DATABASE [tempdb]'
	+	N' MODIFY FILE (NAME = [' + [name] + ']'
	+	N', FILENAME = ''' + REPLACE(physical_name, @original_path, @destination_path) + ''');'
	+	CHAR(10)
FROM	sys.master_files
WHERE	[database_id] = DB_ID('tempdb')
FOR XML PATH(''))

PRINT @sqlcmd
--EXEC(@sqlcmd)