how to Change MD5 Password MSQL

[kaninz4522]

WTF

i want change

help pls.

[MentaL]

[Marlon Colhado]

Go to Functions in MSSQL, (I use Navicat to this..)
Search by FN_CreateMD5Password, and replace this:

ALTER PROCEDURE [dbo].[FN_CreateMD5Password]
    @in_Password varchar(100),
    @out_MD5 varchar(32) OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    declare @PASSWORD_SALT varchar(100) = 'g5sc4gs1fz0h'
    set @out_MD5 = SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('md5', @PASSWORD_SALT + @in_Password)), 3, 999)
END 

To:

ALTER PROCEDURE [dbo].[FN_CreateMD5Password]
    @in_Password varchar(100),
    @out_MD5 varchar(32) OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    declare @PASSWORD_SALT varchar(100) = 'g5sc4gs1fz0h'
    set @out_MD5 = @in_Password
END 

Work?
Like, :)