harriet.louis (7/16/2008)
Hello All,I am hoping you can help. I need to find out if it is possible to read the location of the sql logs from the database. I am aware that it is normally saved at a default location, but it also might be that the user who installed it configured it to be different. I would want to write an application that would do a query to the database and get the path to the log files;
Kind Regards.;)
select physical_name from sys.database_files where type = 1
Regards,
Andras