Type Property (Login)

SQL-DMO

SQL-DMO

Type Property (Login)

The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.

Applies To
Login Object
Syntax

object.Type [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies 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 Referenced login is the name of a Microsoft Windows security group.
SQLDMOLogin_NTUser 0 Referenced login is the name of a Windows user.
SQLDMOLogin_Standard 2 Referenced login is used for SQL Server Authentication. Login name and password may be required when a client connects using the login.

Remarks

When using the Login object to create a SQL Server login record, setting the Type property directs evaluation of other properties. For example, when the Type property specifies that the Name property is interpreted as a Windows NT 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, when the Type property specifies a SQL Server Authentication login record, any setting for the DenyNTLogin property is ignored. For more information, see Login Object.