Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stanley Chan Make a 100+ Server Inventory in 30 minutes RE: Make a 100+ Server Inventory in 30 minutes

  • June 10, 2010 at 3:00 pm

    #1178945

    Phil Factor (6/10/2010)

    This would be handy for a DBA if all the servers are in the domain, but rather than make a batch file with a list of all your servers by hand, you could get the list of all your registered SQL servers very easily from SMO, and, whilst you're doing it, collect as much SQL Server information as you want about them to combine with the systeminfo info.

    Hi Phil... have you got a link for the method you mention above?

    --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)