SQL Server Performance Forum – Threads Archive

SQL-DMO: Default Log directory?

I can get the SQLDataRoot path from a DMO object called Registry.SQLDataRoot. Does anyone know if there’s a way to get the default log path as well, without having to fall back to xp_regread/write? When I trace the set operation in the EM it calls regread/write to get the value…urgh. Thank you.

I haven’t seen any other reference other than reading from registry in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for the reply. Did some searching yesterday and today and it looks like I might have to changeover to the registry read to get the logfile path. Urgh, seriously annoyying that MS doesn’t follow the same method 100% of the time….

]]>