This topic has not yet been rated - Rate this topic

SetPassword Method

SQL Server 2008 R2

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 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);

Remarks

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:

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD