Hi Jim

While I do understand the issue you solve here, I have some questions about the strategy in this post.

The merge statement updates every login that has...

It is possible that you need to configure a firewall exception:

computer configuration>administrative templates>network>network connections>windows firewall>domain policy

"allow remote administrative exceptions"enabled, allow unsolicited incoming messages from: "localsubnet"

This policy opens TCP-ports...

That's nice

I added some feedback, so I can see what module has finally been imported. When you choose a version that is not present, the function will do nothing, and...

Laerte

de fato

I forgot that Import-Module SQLPS is in my profile. If I remove that, the assemblies are not there.

Searching in the GAC is a better way.

Import-Module SQLPS seems to import...

Thanks Shawn

While I'm playing with these modules, I see strange things:

I have the 110, 120 and 130 versions installed, though only SQL Server Engine 2014 (120), and no SSAS. I...

Bom dia Laerte

To add the assembly I usually go with Import-Module SQLPS, but there are also three versions of that module on my PC. How do I know which one...

I think being an admin isn't enough: you can only change executionpolicy if you start Powershell with elevated permissions (run as administrator).

That 's much easier than I expected.

I found a T-sql script, but I prefer the Powershell way.

I added those 4 lines as Step 10 in the Database Mail setup script,...

Great Bruce

Another wizard I will never open again because I now have the perfect script to replace it!

I just added [cmdletbinding()] and the server name as a param.

Now working on...