Type Property (Login)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

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.

Remarks

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 Type property 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.

Applies To:

Login Object