BrianMc1958
asked on
Can DatabaseMetaData return physical file names for MS SQL db?
Dear Experts,
I'm trying to return the physical file names of MS SQL data and log files. (Like "C:\MyDir\MyData.mdf"). Someone suggested using SYSALTFILES, but it requires extra authority. Does anyone know if it's possible through DatabaseMetaData, or some other way throught JDBC?
Thanks!
BrianMc1958
I'm trying to return the physical file names of MS SQL data and log files. (Like "C:\MyDir\MyData.mdf"). Someone suggested using SYSALTFILES, but it requires extra authority. Does anyone know if it's possible through DatabaseMetaData, or some other way throught JDBC?
Thanks!
BrianMc1958
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.