Hi,

the following is taken from BOL (see sp_password)

sp_password [ [ @old = ] 'old_password' , ]

{ [ @new =] 'new_password' }

[ , [ @loginame = ] 'login' ]

HTH

Cheers,

Frank