How do I make a md5 password ??
I used the

But, If I want to put the password in the code from sedrika, the account make code ill get this error:
Code:
Msg 207, Level 16, State 1, Line 2 Invalid column name 'OldPassword'. Msg 207, Level 16, State 1, Line 2 Invalid column name 'TempPassword'. Msg 2601, Level 14, State 1, Line 2 Cannot insert duplicate key row in object 'dbo.ACCOUNT_TBL_DETAIL' with unique index 'ACCOUNT_TBL_DETAIL_ID1'. The statement has been terminated.
Thx
Dope






