Changing the the superuser "sa" password in Microsoft SQL is an ordeal involving the MS "SQL Enterprise Manager".
Changing the "sa" password in the free-but-broken Microsoft SQL Desktop Engine (MSDE) is as far as I know impossible.

It's a lot easier in Perl. Open a regular ODBC connection to the database in question and voila:
use warnings; use strict; use DBI; my $dbh = DBI->connect('dbi:ODBC:target', 'sa', 'password'); $dbh->do("exec sp_password password, newpassword");

Replies are listed 'Best First'.
Re: Change "sa" password in MSSQL
by Anonymous Monk on Aug 12, 2004 at 18:14 UTC
    It is amazing that Microsoft has done such a crappy job with MSSQL that this trival script is actually useful. ++ to you!