SQL Server Administration

Here’s a quick T-SQL tip on getting the paths for all database files in a SQL Server instance.   The T-SQL Tip You can get the list of paths for all database files (both data and log files) using the undocumented SQL Server stored procedure sp_MSforeachdb. You can use the below T-SQL statement: exec sp_MSforeachdb @command1=”USE … Read more…