I was asked to findout total size of all the backup files in the folder As I didnt have access to view the folder of the server , I used this . I hope it may be helpful create table #t ( files varchar ( 1000 )) Insert into #t EXEC master .. xp_cmdshell 'dir e:\backup' select substring ( size_files...