Open Powershell in admin mode
Copy and Paste the script
Make sure you change the path of the serverlist with your valid sql server details.
Finally, Run it.
Open Powershell in admin mode
Copy and Paste the script
Make sure you change the path of the serverlist with your valid sql server details.
Finally, Run it.
$OutputPath = "C:\Powershell\SQL Script\NO_DB_Permissions\output.txt";
$cyclecount = 1
try
{
foreach ($svr in get-content "C:\Powershell\serverlist.txt")
{
"****SERVER NAME****:$($svr)" | out-file $OutputPath -append
"----------------------------------------------------------------------" | out-file $OutputPath -append
Write-Host "Processing Server: $($svr), Cycle : $($cyclecount)" -Fore Red
Invoke-Sqlcmd -inputfile "C:\Powershell\SQL Script\NO_DB_Permissions\nodbpermissions.sql" -ServerInstance $svr | Out-File -filepath $OutputPath -append
Write-Host "Processing completed on Server: $($svr)" -Fore Green;
$cyclecount += 1
}
}
catch
{
Write-Warning "Error processing command";
$error[0];
$Exception = $Error[0].Exception
}
finally
{
$ErrorActionPrefernce = $eap
}