Post reply

Server level triggers

  • March 27, 2019 at 6:13 pm

    #2033887

    I have triggers created at server level for alerts. However, there are new sql servers get created more often. I would like to automate this whenever there is a new sql server gets added i would like to add this trigger by the process instead of manually.

  • March 27, 2019 at 7:22 pm

    #2034040

    Do you already have an automated way to install and configure SQL Server? If so, you should be able to script out the existing trigger in SSMS and add that to your deployment process. PowerShell is great for this.

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

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