SQLServer Object Properties Methods Lists Collections
| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| ApplicationName String Write: Before Connect |
The name of the application. Supplied by the application. This property can be changed after a DisConnect and before a ReConnect. |
| AutoReConnect Type: Boolean Write: Yes |
Determines if SQL-DMO will automatically reestablish broken connections. If True, a connection broken before an operation will be reconnected automatically. If False, broken connections are not reconnected automatically. |
| CommandTerminator String Write: Yes |
The Transact-SQL command terminator. The default is "go". |
| Configuration Configuration Write: No |
The Configuration object for this SQLServer. |
| ConnectionID Long Write: No |
The SQL-DMO connection ID unique for this SQL-DMO instance. |
| DistributionDatabase String Write: No |
The replication distribution database. |
| DistributionServer String Write: No |
The replication distribution server. |
| DistributionWorkingDirectory String Write: Yes |
The replication distribution working directory. |
| Executive Executive Write: No |
The Executive object for this SQL Server. |
| HostName String Write: Before Connect |
The name of the client computer. Supplied by the application. This property can be changed after calling DisConnect and before calling ReConnect. |
| IntegratedSecurity IntegratedSecurity Write: No |
The IntegratedSecurity object. |
| Language String Write: Yes |
The Language used by the SQL Server. |
| Login Identifier Write: Before Connect |
The login ID used to connect to SQL Server. Supplied by the application. |
| LoginSecure Boolean Write: Before Connect |
Determines if a secure connection is requested when the Connect method is called. If True, a secure connection is requested. If False, a normal connection is requested. |
| LoginTimeout Long Write: Before Connect |
The number of seconds to wait for a connection attempt to succeed. The default is -1 which means 60 seconds. A value of 0 means no timeout. |
| MaxNumericPrecision Long Write: No |
The maximum precision available for exact numeric datatypes, including decimal and numeric. |
| Name String Write: Before Connect |
The name of the SQL Server. Supplied by the application. |
| NetPacketSize Long Write: Before Connect |
The network packet size in bytes. The default is 0 which means 4096 bytes. |
| NextDeviceNumber Long Write: No |
The next available device number. The maximum device number is 256. |
| Parent Application Write: No |
The Application object. |
| Password Identifier Write: Before Connect |
The password used to connect to SQL Server. Supplied by the application. |
| ProcessID Long Write: No |
The SQL Server process ID of the connection used by the SQLServer object. |
| QueryTimeout Long Write: Yes |
The number of seconds to wait for a query execution attempt to begin returning results. The default is -1 which means no timeout. A value of 0 also means no timeout. |
| Registry Registry Write: No |
The Registry object for this SQL Server. |
| SaLogin Boolean Write: No |
Indicates if the login used for the connection has system administrator (SA) privilege. |
| Status SQLOLE_SVCSTATUS_TYPE Write: No |
The service status of the SQL Server. |
| TrueLogin Identifier Write: No |
The real login used of the connection to SQL Server. This may be different than Login for a secure connection. |
| TrueName Identifier Write: No |
The name of the SQL Server stored in @@servername. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |
| UserProfile SQLOLE_SRVUSERPROFILE_TYPE Write: No |
The SQL Server profile information for the currently connected user. |
| VersionMajor Long Write: No |
The SQL Server version number to the left of the decimal point. |
| VersionMinor Long Write: No |
The SQL Server version number to the right of the decimal point. |
| VersionString String Write: No |
The version of the SQL Server stored in @@version. |