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.

    Haywood, Apr 17, 2006
    #2

  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.
    satya, Apr 18, 2006
    #2

  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....
    Haywood, Apr 18, 2006
    #2

Share This Page