My good friend Tom has a very cool solution too, but this script was published in SSC in first time I guess in 2008 or 2009 (you can check by...

Iwas Bornready and Perry Whittle, Thanks guys !!! Glad you liked !!!

Cool man.. That´s it

The import-module SQLPS just makes the job to load the assembly for you. I , particularly, like to load the assemblies manually, but that´s me !!!...

Awesome man!!! I already added this function to my toolbelt

BTW, the order is, according the Master Jedi Joel Bennet (Jaykul)

"Path order, then alphabetic order, then highest version if you...

Hey man, just got the confirmation. It is by the path order in the $env:psmodulepath that import-module load when using just the name, not the full path .

The Shanw´s function...

Actually my friend, I have installed the other version of SQL Server in a VM to test for you, but I forgot to restart my VM to update the environment...

Bom dia Meu amigo 🙂

This code is pretty cool, but you run it without load the SMO it will not returns to you the highest one ..actually will not returns...

Just a complementar information about write-output and write-host.

Write-output writes the output to the pipeline (what you should want to do it, since powershell is a object-oriented shell).

Write-host takes all...

Just a comment, you are not installing anything. it is a open source library, you can check the code and it is only copy and paste the modules It is...

If you get-member in get-sqldata you will see that it returns a System.Data.DataRow and the properties related to your query. This is what you need to use :

In you query,the...

To get the SQL Server info,

[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") > $null

$server = new-object ('Microsoft.SqlServer.Management.Smo.Server') 'SQLName'

#You can select all the properties

$server

#Just version and edition and language

$server | select version, edition,language

Or we can...

For me the best book ever on Posh V2 :

Windows PowerShell In Action 2d, Bruce Payette

I dont know if I understand vey well,but if you want to get the last line and output to a new file :

(Get-Content c:\Test\lines.txt )[-1] | Out-File c:\test\NewLine.txt

Then same...

Great info man !!! Thanks 🙂

Humm Interesting..I had read it but not tried. Let me understand, your proxy account MyAuthenticatedUser was just open WMI Control (wmimgmt.msc) and grant Remote Enable on the ROOT\CIMV2 namespace ?

And...