SQL-DMO
SQL Server Connection Constants (SQLDMO_VERIFYCONN_TYPE)
Microsoft® SQL Server™ connection constants direct the action of the VerifyConnection method of the SQLServer object.
| Constant | Value | Description |
|---|---|---|
| SQLDMOConn_CurrentState | 2 | Returns TRUE if connected. |
| SQLDMOConn_LastState | 1 | Returns TRUE if connected on last call and still connected, or not connected on last call and still not connected. |
| SQLDMOConn_ReconnectIfDead | 6 | Default. Attempts to reconnect the SQLServer object if the object has been connected and has lost its connection. Returns TRUE if connection exists. |
| SQLDMOConn_Valid | 7 | All SQL Server connection constants combined by using an OR logical operator. |