This topic has not yet been rated - Rate this topic

MultiServerSqlConnectionInfo Class

SQL Server 2012

SQL Server 2008 R2

Contains SQL Server connection information that is used by Transact-SQL query editors.

System.Object
Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo
Microsoft.SqlServer.Management.MultiServerConnection.MultiServerSqlConnectionInfo

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

Syntax

C++

JScript

public class MultiServerSqlConnectionInfo : UIConnectionInfo

The MultiServerSqlConnectionInfo type exposes the following members.

Constructors

	Name	Description
	MultiServerSqlConnectionInfo()	Initializes a new instance of the MultiServerSqlConnectionInfo class.
	MultiServerSqlConnectionInfo(UIConnectionInfo)	Initializes a new instance of the MultiServerSqlConnectionInfo class with the specified connection information.

Top

Properties

	Name	Description
	AdvancedOptions	(Inherited from UIConnectionInfo.)
	ApplicationName	(Inherited from UIConnectionInfo.)
	AuthenticationType	(Inherited from UIConnectionInfo.)
	ConnectionProtocolString	Specifies the name of the network protocol to use for the connection.
	ConnectionTimeout	Gets or sets the connection timeout interval to the server, in seconds.
	DefaultDatabaseName	Gets or sets the name of the database to connect to by default.
	DisplayName	(Inherited from UIConnectionInfo.)
	EncryptConnection	Gets or sets a value specifying whether the connection will be encrypted.
	EncryptedPassword	(Inherited from UIConnectionInfo.)
	ExecutionTimeout	Gets or sets the execution timeout interval for a Transact-SQL batch, in seconds.
	Id	(Inherited from UIConnectionInfo.)
	NetworkProtocol	Specifies the type of network protocol that will be used by the connection.
	OtherParams	(Inherited from UIConnectionInfo.)
	PacketSize	Gets or sets size, in bytes, of the TCP packets used by the connection.
	Password	(Inherited from UIConnectionInfo.)
	PersistPassword	(Inherited from UIConnectionInfo.)
	ServerName	(Inherited from UIConnectionInfo.)
	ServerNameNoDot	(Inherited from UIConnectionInfo.)
	ServerType	(Inherited from UIConnectionInfo.)
	ServerVersion	(Inherited from UIConnectionInfo.)
	UserName	Gets or sets the name of the login to use when connecting. (Overrides UIConnectionInfo.UserName.)
	UseWindowsAuthentication	Gets or sets a value indicating whether Windows Integrated Security Authentication will be used.
	WorkstationId	Gets or sets the name of the client machine submitting the Transact-SQL batch.

Top

Methods

	Name	Description
	CompareTo	(Inherited from UIConnectionInfo.)
	Copy	(Inherited from UIConnectionInfo.)
	CreateSqlConnection	Creates a connection to the server.
	Equals	(Inherited from UIConnectionInfo.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from UIConnectionInfo.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	SaveToStream	(Inherited from UIConnectionInfo.)
	ToString	(Inherited from Object.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.Management.MultiServerConnection Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD