SELECT ‘ALTER DATABASE tempdb MODIFY FILE (NAME = [‘
+ f.name
+
‘],’
+ ‘ FILENAME = ”F:\’ + f.name
+ CASE WHEN f.type = 1 THEN ‘.ldf’ ELSE ‘.mdf’ END
+ ”’);’
FROM sys.master_files f
WHERE f.database_id = DB_ID(N’tempdb’);
Vincent Stefanetti – MAX ERP Consultant
Vincent Stefanetti – MAX ERP Consultant