Home Forums SQL Server 2008 T-SQL (SS2K8) How to create numerous directories on a server using data from sql table RE: How to create numerous directories on a server using data from sql table

  • No...MUCH worse!

    xp_CmdShell --> PowerShell --> WMI --> Return through OUTPUT of xp_CmdShell to table via persisted computed columns --> XML --> HTML --> SP_SendDBMail. 😀 I use it to build my "Enterprise Wide Disk Status Morning Report" with colors for the different "Percent Full". It also has a special section so that the folks in NetOps can find any CDs or ThumbDrives they may have left in the machines and lost track of.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)