Task using TSQL instead of VbScript  
Author Message

PostPosted: Top

SQL Server Developer >> Task using TSQL instead of VbScript

Dear all,

I would need delete files in a set of folders. But in each subfolder of main
folder you find lots of files with the same name but different dates, so the
idea is do a for..each and delete them according a rule. Is not very
impressive using VbScript, you know, just a ****ing task. Then, it might
store in a sql tables the NAME and the DATELASTMODIFIED properties of each
file and then, borrar the ones older than a specified date.

That's fine (more or less) but I was wondering if it could do using just
Transact-SQL and so to avoid use language script.

I am look forward to hearing from you.

Best regards,

SQL Server241