Script:
EXEC msdb.dbo.sp_add_operator @name='ABCXYZ',
@enabled=1,
@weekday_pager_start_time=0,
@weekday_pager_end_time=235900,
@saturday_pager_start_time=0,
@saturday_pager_end_time=235900,
@sunday_pager_start_time=0,
@sunday_pager_end_time=235900,
@pager_days=127,
@email_address='email@email.com',
@pager_address='XX@yy.edu',
@category_name=N'[Uncategorized]'
GO
Msg 1934, Level 16, State 1, Procedure trgDDLChangeLog, Line 9
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.