How to reset the SAP* and DDIC password in MSSQL environment

Question:
Dear All,
We have forgotten the passwords for both SAP* and DDIC for one of the old client.
Anybody can help me out how to reset the password for SAP* and DDIC from databasepoint of view.
Right now we are using MSSQL Server 2000.
Answer:
Make sure the parameter login/no_automatic_user_sapstar is not set and I am sure the rest of how to do it is in this forum
Search works nice

More Articles:

HR mini masters?
how to block schama?
CLIENT COPY PROBLEM........?
Changing name of Infoset?
STMS Configuration?
"cross system" table ?