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