This topic has not yet been rated - Rate this topic

ServerConnection.Copy Method

SQL Server 2012

Returns a copy of the ServerConnection object.

Namespace: Microsoft.SqlServer.Management.Common
Assembly: Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

C++

JScript

public ServerConnection Copy()

Return Value

Type: Microsoft.SqlServer.Management.Common.ServerConnection
A ServerConnection object that is a copy of the referenced ServerConnection object.

Examples

ServerConnection conn = new ServerConnection();
conn.LoginSecure = false;
conn.Login = vlogin;
conn.password = vpassword;
ServerConnection conn2 = conn.Copy()
conn2.StatementTimeout = 450;
Console.WriteLine(conn2.StatementTimeout);
Console.WriteLine(conn.StatementTimeout);

PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
$conn.LoginSecure = $FALSE
$conn.Login = vlogin
$conn.Password = vpassword
$conn2 = $conn.Copy()
$conn2.StatementTimeout = 450
Write-Host $conn2.StatementTimeout
Write-Host $conn.StatementTimeout

Reference

ServerConnection Class

Microsoft.SqlServer.Management.Common Namespace

Other Resources

Calling Methods

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD