sys.sp_password

Description

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

Syntax

sp_password
[ [ @old = ]
N
'old'
]
, [ @new = ]
N
'new'
[ , [ @loginame = ]
N
'loginame'
]
[ ; ]