Change sa Password in MSDE

This is a newbie question but how can I change the sa password in MSDE?
You don't have the graphical tools with MSDE that come with full blown SQL
Server versions, but you have a command line tool that is called osql. You
can run this and then change the sa password with the following SQL
statement (assuming you are logged in as sa):
EXEC sp_password '<old password>', '<new password>'
Jacco Schalkwijk
SQL Server MVP
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?
|||Hi John,
We've also got a tool (MSDE Manager) that's free for personal use. Details
are on our web site. It can do things like this easily.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?