• Jeff Moden (5/4/2015)


    I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking for someone that actually did it this way for a good reason.

    I use PowerShell+SMO to sync Logins between servers, e.g. servers hosting related AlwaysOn replicas and servers related through Log Shipping. It allows me to run the PowerShell script from a central utility server (one that does not necessarily have to have an installed instance of SQL Server) and touch all related servers in the environment. When new servers are added to the environment I add only have to edit the configuration data the PowerShell script refers to in order to get Login syncing working across the new servers.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato