SQL Server Performance

SQL-DMO: Default Log directory?

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by Haywood, Apr 17, 2006.

  1. Haywood New Member

    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.

  2. satya Moderator

    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.
  3. Haywood New Member

    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....

Share This Page