SQL Server Performance

xp_getfiledetails

Discussion in 'General Developer Questions' started by muthur, Oct 24, 2003.

  1. muthur New Member

    Hi,
    I have to find out the version of all the dlls stored under a directory.
    I use the command xp_getfiledetails and it gives the details ( like creation and modified date etc). But it does not give me the version of the dll. Is there any other command to do this?

    Thanks and Regards
    Muthu
  2. satya Moderator

    I haven't seen any such undocumented stored procedure, I think you may need to depend on reading registry keys for those .DLLs by using XP_REGREAD.

    Another disadvantage of using undocument SPs is they may change or unsused after version upgrade.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page