February 16, 2010 at 5:54 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply