共用方式為


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.

Applies To: