• Hello,

    Thanks for your script.

    I'm having a conversion error at the following line :

    update #Files

    set FileSizeInMB = CONVERT(decimal(18,2), FileSize) / 1024 / 1024,

    FileSizeInGB = CONVERT(decimal(18,2), FileSize) / 1024 / 1024 / 1024

    "conversion error from varchar to numeric." (I translate it as I can, I'm using a French OS with SQL Server Express 2005 French ed)

    Do you have any idea on how to solve this ?

    Thanks by advance for your answer,

    Matthieu