How to reset SAP* and DDIC password in MSSQL Server

Reset the SAP* and DDIC password in MSSQL Server using sql query,

1. log in to the Microsoft SQL server.

2. Enter the NEW QUERY.

3. Execute the below Query 

select * from ABC.abc.USR02 where MANDT='000' and BNAME='SAP*'

Result

MANDT       BNAME

000                 SAP*

ABC = SID(database ID)

4.Reset the SAP* and DDIC Password.

delete from ABC.abc.USR02 where MANDT='000' and BNAME='SAP*'

Result

MANDT     BNAME

simply delete the user in particular client the SAP* and DDIC user password has been reset to standard password.

User name     Password

SAP*             PASS,06071992
DDIC            19920706