Restore default setting for MSDE

How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode? And to have my sa account withoutpassword? Please help me! Thanks, Nibbles

Nibbles wrote:

How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode?

This setting cannot be changed with T-SQL as far as I know. Youcan do it with Enterprise Manager, or with your own custom SQL-DMOprogram, or by changing the registry directly.

Nibbles wrote:

And to have my sa account withoutpassword?

Never ever leave the sa account without a pasword! You can change the password using thesp_password system stored procedure.
You will find this article helpful as it addresses both of your needs:How To Verify and Change the MSDE System Administrator Password
sql