• Modify this powershell script to loop through an array of servers and then db list.

    $SQLAdminUser = 'AdminUser'

    $SQLAdminPwd = get-content "PathToSecuredCredentials.txt" | convertto-securestring

    $srvConn = New-Object('Microsoft.SqlServer.Management.Common.ServerConnection') ('ServerName', $SQLAdminUser, $SQLAdminPwd)

    $srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $srvConn

    $srv.Databases | where{$_.Name -eq 'DatabaseName'} |

    foreach {

    $_.SetOwner('sa')

    $_.Alter();

    }