ÿþ<html> <head> <title>Get-SqlVersion</title> </head> <body> <h1>Get-SqlVersion</h1> <div>Returns a custom object with the Server name and version number.</div> <h2> Syntax </h2> <code>Get-SqlVersion [-sqlserver] &lt;Object&gt; [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Get-SqlVersion function returns a custom object with the Server name and version number for the specified SQL server. </div> <h2> Related Commands </h2> <div> * <a href='Get-SqlVersion.htm'>Get-SqlVersion</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>sqlserver&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>None You cannot pipe objects to Get-SqlVersion</div> <h2> Return Values </h2> <div>Selected.Microsoft.SqlServer.Management.Smo.Information Get-SqlVersion returns a Selected.Microsoft.SqlServer.Management.Smo.Information object.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Get-SqlVersion "Z002\sql2k8"</pre> <div>This command returns SQL version information for the Z002\sql2k8 SQL Server.</div> </body> </html>