Link to home
Start Free TrialLog in
Avatar of BrianMc1958
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
ASKER CERTIFIED SOLUTION
Avatar of ysnky
ysnky
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial