Share via

  • Article

Constructeur Server (String)

Initialise une nouvelle instance de la classe Server avec le nom spécifié.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Sub New ( _
    name As String _
)
'Utilisation
Dim name As String

Dim instance As New Server(name)

public Server(
    string name
)

public:
Server(
    String^ name
)

new : 
        name:string -> Server

public function Server(
    name : String
)

Paramètres

Notes

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.

Exemples

Visual Basic

'Connect to a remote instance of SQL Server.
Dim srv As Server
'The strServer string variable contains the name of a remote instance of SQL Server.
srv = New Server(strServer)
'The actual connection is made when a property is retrieved. 
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.

PowerShell

#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