You are the SQL administrator for your company. A SQL Server 2008 computer named Sql3 has several alertsconfigured.
One of the alerts was created using the following Transact-SQL statement:
EXEC dbo.sp_add_alert
@name = ‘Backup Alert’,
@enabled = 1,
@message_id = 0,
@severity = 20,
@notification_message = ‘Error. The database will be backed up.’,
@job_name = ‘Back up the Production Database’;
You need to edit the alert so that the alert has a message ID of 56100. Which Transact-SQL statement should you use?