I have installed MSDE version on my pc but for the same
it have asked me to change the password of SA now i want
to change the password of SA with OSQL utility as i do
not have the Enterprise mangaer. Plese suggest how i can
change the same.
Your earlier reply will be helpful.
Best regards
ShaileshIn Osql you can use the sp_password system SP. Do please check the syntax in
Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"shailesh" <anonymous@.discussions.microsoft.com> wrote in message
news:7a0d01c3e8d5$a3d6fe80$a101280a@.phx.gbl...
quote:|||Hi,
> Dear Friends
> I have installed MSDE version on my pc but for the same
> it have asked me to change the password of SA now i want
> to change the password of SA with OSQL utility as i do
> not have the Enterprise mangaer. Plese suggest how i can
> change the same.
> Your earlier reply will be helpful.
> Best regards
> Shailesh
From command prompt execute
OSQL -Usa -Ppassword -Sservername -Q"sp_password oldpassword,newpassword,sa"
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eVhRceN6DHA.1804@.TK2MSFTNGP12.phx.gbl...
quote:
> In Osql you can use the sp_password system SP. Do please check the syntax
in
quote:
> Books OnLine.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "shailesh" <anonymous@.discussions.microsoft.com> wrote in message
> news:7a0d01c3e8d5$a3d6fe80$a101280a@.phx.gbl...
>
No comments:
Post a Comment