Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ronin2307
Posting Yak Master
126 Posts |
 Posted - 2007-05-21 : 12:12:32
|
| hi,is there an easy way to get the datafile and transaction file paths with a query?I have over 50 different databases on my 2000 sql server and i need review all of the datafile paths for each one. however instead of going into the properties of each and every db i was hoping to write a query to give me that infoany help will be appreciated.Thanx |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-21 : 12:24:00
|
| Query sysfiles table.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
ronin2307
Posting Yak Master
126 Posts |
Posted - 2007-05-21 : 12:32:01
|
| what does the query look like? |
|
|
|
ronin2307
Posting Yak Master
126 Posts |
Posted - 2007-05-21 : 12:35:01
|
| ignore the previous post, but hear me outselect * from sysfiles gives me the path for the db I am in and not ALL DBs on the server...kinda the same deal i was trying to avoid |
|
|
|
|
|
|
filepaths query