Solved

Can DatabaseMetaData return physical file names for MS SQL db?

Posted on 2007-11-19
1
201 Views
Last Modified: 2010-03-30
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
0
Comment
Question by:BrianMc1958
1 Comment
 
LVL 9

Accepted Solution

by:
ysnky earned 500 total points
ID: 20314665
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question