Any suggestions? Export (0) Print
Expand All

Server Constructor (String)


Initializes a new instance of the Server class with the specified name.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

new : 
        name:string -> Server


Type: System.String

A String value that specifies the name of the instance of SQL Server.

Use this constructor when the required instance of SQL Server is not the local, default instance. You can use this method when the SQL Server instance is local, but is not the default installation. You can also use this method for remote instances of SQL Server.

Visual Basic


#the strServer string variable contains the name of a remote instance of SQL Server.
$srv = new-object Microsoft.SqlServer.Management.Smo.Server($strServer)
#The actual connection is made when a property is retrieved.
Write-Host $srv.Information.Version
Return to top
© 2015 Microsoft