xp_cmdshell work-around??

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  January 21, 2009 at 7:51 am

  #128155

  Hello,

  mssql 2005

  For growth analysis, I need to capture the *.bak file sizes for a given folder. Currently I am doing this using xp_cmdshell, and inserting a DIR listing into mssql table, then cleaning/converting data to get achieved results.

  I would like to avoid using this xp, and disable this feature re: "Surface Area Configuration".

  Any suggestions on a work around?

  Thanks. Jeff

  Many thanks. Jeff

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736557

  More actions

  January 21, 2009 at 7:56 am

  #930356

  why use xp_cmdshell? I'd script this outside of SQL (VBScript/Powershell) and have the data inserted. Then you can easily call this from SQL Agent.

• john.danley

  SSC Eights!

  Points: 906

  More actions

  January 21, 2009 at 8:16 am

  #930381

  I do this very thing. It uses one stored proc and a job with two steps. I got this from: http://www.databasejournal.com/features/mssql/print.php/10894_3414111_2