change standard security password of sa

Dear All,
I failed to change the standard security password of sa
which is generated automatically. Whatever I changed it by
the function sp_password and it alerted successful. The
password of sa is still the same as before. How to change
the password of sa ......../.According to Books Online:
sp_password [ [ @.old =3D ] 'old_password' , ] { [ @.new =3D] 'new_password' } [ , [ @.loginame =3D ] 'login' ]
So, you would use something like this:
sp_password 'thecurrentpassword', 'thenewpassword', 'sa'
-- Keith
"ken" <anonymous@.discussions.microsoft.com> wrote in message =news:09c701c3c626$86cca000$a301280a@.phx.gbl...
> Dear All,
> I failed to change the standard security password of sa
> which is generated automatically. Whatever I changed it by
> the function sp_password and it alerted successful. The
> password of sa is still the same as before. How to change
> the password of sa ......../.|||When SQL Server is isntalled the sa password in NULL. There is not
automatically generated password. So if after installation the password for
sa in not NULL then someone is changing it after the installation.
Rand
This posting is provided "as is" with no warranties and confers no rights.