Hi Steve

EXEC sp_password NULL, 'password', 'sa';

... you need to be sysadmin to do this

But before doing this I would run the Profiler to monitor any logins with
sa
It could be that some applications use this account to update data (don't
laugh - I've seen this!)
... they will break if you change the password ...

Good luck
Daniel




"Steve Faulkner " <mssqldba-ezmlmshield-x62584036.[Email address protected]

27.04.2007 12:24

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Changing sa account details






Hi Guys,



Probably a really stupid question and I'll most likely kick myself when
I find out the answer or not as case may be.



I have full administrative rights to a sql instance I have inherited -
however the sa password is not known by anybosy - is there a way to
either change it or find out what it is from the system?



Thanks

Steve


________________________________________________________________________
FFastFill plc is a public limited company registered in England and Wales
with details as follows;
Registered Office: 1-3 Norton Folgate, London E1 6DB Company Number:978346

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[Email address protected]

This email has been scanned for all viruses by the FFastFill Email
Security System.
________________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail may contain confidential material. It is intended only for the person or entity which it is addressed to. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this e-mail in error, please immediately notify the sender or The Swiss Raiffeisen Group and delete the material from any and all computers it may be stored on. Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of The Swiss Raiffeisen Group. Therefore this e-mail does not represent a binding agreement nor an offer to deal. E-mail transmission cannot be guaranteed to be secure or error-free. Information could be intercepted, corrupted, lost, destroyed, incomplete or may contain viruses. Neither The Swiss Raiffeisen Group nor the sender can accept any liability for any kind of damage as the result of viruses or transmission errors.
**********************************************************************


MS Sql Server LazyDBA home page