Hi guys,
i m working on a script to find old backups in all disk drives.
i have reached a part where i have the full path of all backup files in temp table.
but i m not able to get file date.i was trying to use xp_getfiledetails but it has been removed from 2005 onwards.
so i was thinking of incorporating vbscript in t-sql as a function. like if we pass the path as a variable it will return the last modified date.
Can it be done?
Or is there any other option?