Constructeur Server (ServerConnection)
Initialise une nouvelle instance de la classe Server en fonction de la connexion spécifiée.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Sub New ( _
serverConnection As ServerConnection _
)
'Utilisation
Dim serverConnection As ServerConnection
Dim instance As New Server(serverConnection)
public Server(
ServerConnection serverConnection
)
public:
Server(
ServerConnection^ serverConnection
)
new :
serverConnection:ServerConnection -> Server
public function Server(
serverConnection : ServerConnection
)
Paramètres
- serverConnection
Type : Microsoft.SqlServer.Management.Common. . :: . .ServerConnection
Valeur de l'objet ServerConnection qui spécifie la connexion à l'instance de SQL Server.
Exemples
Visual Basic
'Connect to the local, default instance of SQL Server.
Dim srv1 As Server
srv1 = New Server()
'Modify the default database and the timeout period for the connection.
srv1.ConnectionContext.DatabaseName = "AdventureWorks2008R2"
srv1.ConnectionContext.ConnectTimeout = 30
'Make a second connection using a copy of the ConnectionContext property and verify settings.
Dim srv2 As Server
srv2 = New Server(srv1.ConnectionContext.Copy)
Console.WriteLine(srv2.ConnectionContext.ConnectTimeout.ToString)
PowerShell
#Connect to the local, default instance of SQL Server.
$srv1 = new-object Microsoft.SqlServer.Management.Smo.Server
#Modify the default database and the timeout period for the connection.
$srv1.ConnectionContext.DatabaseName = "AdventureWorks2008R2"
$srv1.ConnectionContext.ConnectTimeout = 30
#Make a second connection using a copy of the ConnectionContext property and verify settings.
$srv2 = new-object Microsoft.SqlServer.Management.Smo.Server($srv1.ConnectionContext.Copy)
Write-Host $srv2.ConnectionContext.ConnectTimeout.ToString()
Voir aussi