ServerConnection Properties
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms218692.pubproperty(en-US,SQL.90).gif") |
ApplicationName |
Gets or sets the name of the application that has established the connection with the server.
(inherited from ConnectionSettings ) |
|
AutoDisconnectMode |
Gets or sets the automatic disconnection mode of the referenced connection to the instance of SQL Server.
(inherited from ConnectionManager ) |
|
BatchSeparator |
Gets or sets the string value used to separate batches in the referenced connection.
|
|
CapturedSql |
Gets the Transact-SQL statements that are captured when the connection is running in capture mode.
(inherited from ConnectionManager ) |
|
ConnectAsUser |
Gets or sets the Boolean property value that specifies whether the connection is established using impersonation.
(inherited from ConnectionSettings ) |
|
ConnectAsUserName |
Gets or sets the name of the user when connecting using impersonation.
(inherited from ConnectionSettings ) |
|
ConnectAsUserPassword |
Gets or sets the password for the user when connecting using impersonation.
(inherited from ConnectionSettings ) |
|
ConnectionString |
Gets or sets the connection string used to establish a connection with a specified data source.
(inherited from ConnectionSettings ) |
|
ConnectTimeout |
Gets or sets the connection time-out period in seconds.
(inherited from ConnectionSettings ) |
|
DatabaseName |
Gets or sets the database required by the connection.
(inherited from ConnectionSettings ) |
|
EncryptConnection |
Gets or sets the Boolean property value that specifies whether the connection is encrypted.
(inherited from ConnectionSettings ) |
|
FixedServerRoles |
Gets the fixed server role associated with the referenced connection.
|
|
InUse |
Gets or sets the Boolean property value that specifies whether the connection is being used.
(inherited from ConnectionManager ) |
|
IsOpen |
Gets the Boolean property value that specifies whether the connection is currently open.
(inherited from ConnectionManager ) |
|
LockTimeout |
Gets or sets the time in seconds required for the connection to time out when the current transaction is locked.
(inherited from ConnectionManager ) |
|
Login |
Gets or sets the logon required to establish a connection with the instance of the server.
(inherited from ConnectionSettings ) |
|
LoginSecure |
Gets or sets the Boolean property that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication.
(inherited from ConnectionSettings ) |
|
MaxPoolSize |
Gets or sets the maximum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server.
(inherited from ConnectionSettings ) |
|
MinPoolSize |
Gets or sets the minimum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server.
(inherited from ConnectionSettings ) |
|
MultipleActiveResultSets |
Gets or sets the Boolean property value that specifies whether more than one active result set is permitted.
(inherited from ConnectionSettings ) |
|
NetworkProtocol |
Gets or sets the network protocol used to establish the connection to the server.
(inherited from ConnectionSettings ) |
|
NonPooledConnection |
Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled.
(inherited from ConnectionSettings ) |
|
PacketSize |
Gets or sets the packets of data sent between the client and the server over the network in bytes.
(inherited from ConnectionSettings ) |
|
Password |
Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used.
(inherited from ConnectionSettings ) |
|
PooledConnectionLifetime |
Gets or sets the lifetime of the pooled connection.
(inherited from ConnectionSettings ) |
|
ProcessID |
Gets the ID value that uniquely identifies the process associated with the referenced connection to the server.
|
|
SecurePassword |
Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used.
(inherited from ConnectionSettings ) |
|
ServerInstance |
Gets or sets the name of the server.
(inherited from ConnectionSettings ) |
|
ServerVersion |
Gets the version of the connected instance of SQL Server.
(inherited from ConnectionManager ) |
|
SqlConnectionObject |
Gets the connection object.
(inherited from ConnectionManager ) |
|
SqlExecutionModes |
Gets or sets the execution mode associated with the referenced connection to the server.
|
|
StatementTimeout |
Gets or sets the number of seconds a statement is given to run before failing with a time-out error.
|
|
TransactionDepth |
Gets the current transaction depth for the referenced connection.
|
|
TrueLogin |
Gets the current logon record name used by the referenced connection.
|
|
TrueName |
Gets the name of the server.
|
|
UserProfile |
Gets the user profile associated with the referenced connection.
|
|
WorkstationId |
Gets or sets the ID value that uniquely identifies the workstation.
(inherited from ConnectionSettings ) |
See Also
Reference
ServerConnection Class
Microsoft.SqlServer.Management.Common Namespace
Other Resources
How to: Connect to the Local Instance of SQL Server by Using Windows Authentication in Visual Basic .NET
Connecting to an Instance of SQL Server