Change Password

[rkbnair]

I want to change the password of a login user. So I pulled the password information
from the syslogin table(after login in as 'sa') and ran the sp_password stored
procedure.

exec sp_password '" + IIf(IsNull(rsLogin.Fields("password").Value) = True,
Null, rsLogin.Fields("password").Value) + "', 'ocean','User A'"


This didn't work. It says the old password is wrong. When I went in the debug
mode, it showed the old password value but in unreadable fashion.

Help please.

[David Satz]

If you are logged in as 'sa', then just do something that shown in BOL:
EXEC sp_password NULL, 'ok', 'Victoria'
use NULL for the old password

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
news:3c8e093a$1@10.1.10.29...
>
> I want to change the password of a login user. So I pulled the password
information
> from the syslogin table(after login in as 'sa') and ran the sp_password
stored
> procedure.
>
> exec sp_password '" + IIf(IsNull(rsLogin.Fields("password").Value) = True,
> Null, rsLogin.Fields("password").Value) + "', 'ocean','User A'"
>
>
> This didn't work. It says the old password is wrong. When I went in the
debug
> mode, it showed the old password value but in unreadable fashion.
>
> Help please.
>