Check Existence of Server and find Instance Type

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 26, 2015 at 3:08 pm

  #316746

  Comments posted to this topic are about the item Check Existence of Server and find Instance Type

  Thanks.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 29, 2015 at 11:05 pm

  #1787210

  Before the syntax :-

  $serverObject = New-Object Microsoft.SqlServer.Management.Smo.Server($instance)

  You can add including the below syntax to load the SMO component DLL.

  Add-Type -Path "C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

  Thanks.