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