How to update the database email password

• k.solai 53753

  SSC-Addicted

  Points: 448

  More actions

  February 16, 2010 at 5:54 am

  #215730

  Dear ALL,

  I have the below query and i want to update the password, when i updating the password it reseting to the old one new password is not updating please help me on this topic.

  If (@ConfigName = 'SMTPServer')

  BEGIN

  EXECUTE msdb.dbo.sysmail_update_account_sp

  @account_id = 1,

  @account_name = 'SMS-DB-MAILS',

  @mailserver_name = @ConfigValue

  END

  If (@ConfigName = 'SMTPUserName')

  BEGIN

  EXECUTE msdb.dbo.sysmail_update_account_sp

  @account_id = 1,

  @account_name = 'SMS-DB-MAILS',

  @email_address = @ConfigValue,

  @username = @ConfigValue

  END

  If (@ConfigName = 'SMTPPassword') -- NEED TO CHECK WITH PASSWORD UPDATE BEGIN

  DECLARE @CURRUSERNAME VARCHAR(50)

  SET @CURRUSERNAME = (SELECT ConfigValue FROM tbl_mGlobalConfig WHERE configName = 'SMTPUserName')

  SELECT @ConfigValue

  exec PROC_SMS_MASTER_GLOBALCONFIG @PROCTYPE=N'UPDATE',@CONFIGUID=6,@CONFIGNAME=N'SMTPPassword',@CONFIGVALUE=N'2',@UPDATEDBY=1

  EXECUTE msdb.dbo.sysmail_update_account_sp

  @account_id = 1,

  @account_name = 'SMS-DB-MAILS',

  @username = @CURRUSERNAME,

  @password = @ConfigValue

  END