Home Forums SQL Server 2008 SQL Server 2008 - General logical and physical file names of all databases RE: logical and physical file names of all databases
vishe.dinesh
SSC-Addicted
Points: 482
More actions
February 13, 2015 at 12:53 am
#1777420
SQLCMD -S . -d Operdb -E -Q “SELECT DB_NAME(database_id) AS DatabaseName, name AS LogicalFileName, physical_name AS PhysicalFileName
FROM sys.master_files AS mf” -s “,” -o “C:\result.csv”
it come outside from command prompt.. how to use ?