Locating log and data files on MSDE using queries 1

[ribsa3]

Hi there

I was wondering how to query a database to have it tell me where its related database and log files are located in the filesystem.

Thanks in advance!

Kindly,
Bjoern Sandvik



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.

 

[vongrunt]

Check system table sysfiles.