SQL Server : sp_send_dbmail

  • Hi all,
    I need help.
    I changed the SP [msdb].[dbo].[sp_send_dbmail], adding a new parameter.
    There is some time when this Sp is restarted?
    This is because SP returns to its initial configuration, losing the changes I made.

    Thanks and regards.

  • mwamoreira - Tuesday, September 4, 2018 4:12 AM

    Hi all,
    I need help.
    I changed the SP [msdb].[dbo].[sp_send_dbmail], adding a new parameter.
    There is some time when this Sp is restarted?
    This is because SP returns to its initial configuration, losing the changes I made.

    Thanks and regards.

    It could have been replaced with a patch or update. You would want to find a different way to address your issue rather than changing sp_send_dbmail.
    The problem isn't losing the changes as much it is changing Microsoft stored procedures. You would really really want to know what you are doing if you try something like this. And you would know about losing the changes if you really know what you need to know to do something like this.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply