SetPassword Method

  • Artikel

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The SetPassword method changes the password for the referenced login.

Syntax

object
.SetPassword(
OldValue
,
NewValue
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • OldValue
    String that specifies the current password string.
  • NewValue
    String that specifies a new password for the login record.

Prototype (C/C++)

HRESULT SetPassword(
SQLDMO_LPCSTR OldValue,
SQLDMO_LPCSTR NewValue);

Hinweise

Use the SetPassword method to alter a password for a login record used by SQL Server Authentication only.

The current password need not be known when setting a new password using the SetPassword method. Use an empty string to specify no password for either the existing password or a new password for the login.

Changing Microsoft SQL Server login passwords using the SetPassword method requires appropriate permissions. The SQL Server login used for SQLServer object connection must be a member of the fixed role sysadmin.

Applies To:

Login Object