Type Property (Login)
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Синтаксис
object.Type [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies a SQL Server login record source as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write when using the Login object to define a new SQL Server login. Read-only when the Login object references an existing login.
Prototype (C/C++)
HRESULT GetType(SQLDMO_LOGIN_TYPE* pRetVal)
HRESULT SetType(SQLDMO_LOGIN_TYPE NewValue)
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMOLogin_NTGroup |
1 |
The referenced login is the name of a Microsoft Windows security group. |
SQLDMOLogin_NTUser |
0 |
The referenced login is the name of a Windows user. |
SQLDMOLogin_Standard |
2 |
The referenced login is used for SQL Server Authentication. A login name and password may be required when a client connects using the login. |
Замечания
When the Login object is used to create a SQL Server login record, setting the Type property directs evaluation of other properties. For example, if the Typeproperty specifies that the Name property is interpreted as a Windows user or group, Windows Authentication is used for the login created and any setting for the Password property is ignored when the Login object is added to its containing collection. Similarly, if the Type property specifies a SQL Server Authentication login record, any setting for the DenyNTLogin property is ignored. For more information, see Login Object.